Activity overview
Latest activity by Barry H
Automation of DB linking
Hi,
Does anyone know if it is possible to automate the linking of databases? We have a number of DB's that we want to put under source control, rather than all of our team having to manually link ...
Hi,
This issue comes with column level permissions on a view. Code below
In the database it is: GRANT SELECT ([ColumnName]) ON [dbo].[vwViewName] TO [Role]
When you select the commit changes window you see this GRANT SELECT ON [dbo].[vwViewName] TO [Role]
It seems to be ignoring the column permissions and granting select on the whole object.
Apologies for replying through the forum, I couldn't workout how to get to the support ticket
[/img] / comments
Hi,
This issue comes with column level permissions on a view. Code below
In the database it is:GRANT SELECT ([ColumnName]) ON [dbo].[vwViewName] TO [Role]
...
Hi,
Thanks for your response. I have had another look at this and it still doesn't appear to be doing what im after.
What I was looking for was to be able to add a user and all table, views, functions and SP and be able to see what objects that user has permissions to.
Barry / comments
Hi,
Thanks for your response. I have had another look at this and it still doesn't appear to be doing what im after.
What I was looking for was to be able to add a user and all table, views, funct...
Column Level Permission in SSC
Hi,
We are in the process of evaluating SQL Source control and have come across an issue.
When linking our databases to SSC with a TFS backend, it seems to have a problem with view that have column...
Using SQL Source Control to Version multiple environments
Hi All,
I wonder if anyone can help, I work within a small team of developers and we are just looking at implementing the SQL Source Control tool and have hit a couple of stumbling blocks.
What we ...
Tracking Permission Dependencies
Hi All,
Is it possible to track the dependent objects of a particular user or role? Also is it possible to show server login's in SQL Dependency Tracker?
Barry