November 1, 2012 at 8:17 am
what is the query to provide alter permissions on views to a user in a database
November 1, 2012 at 8:27 am
here is a good post to familiarise yourself with SQL Server security:
http://blog.sqlauthority.com/2012/04/23/sql-server-introduction-to-sql-server-security-a-primer/
SQL Server Security blog: http://blogs.msdn.com/b/sqlsecurity/
Grant statement from BOL: http://msdn.microsoft.com/en-us/library/ms187965.aspx (see links at bottom of article to see the related topics)
essentially, something like GRANT SELECT ON view1 TO user1
November 1, 2012 at 9:50 am
If I understand, you want to allow a user to change permissions on a view they have access to, correct? Not change the view, but the permissions?
I think you need the "WITH GRANT" option on permissions.
November 1, 2012 at 10:05 am
Apologies - if you meant what Steve Jones wrote, then as he said, the WITH GRANT option is what you want:
If WITH GRANT is included in the (GRANT permission) statement, then the user affected is also permitted to grant these same permissions to other users. Note that the WITH GRANT OPTION can not be specified when the permissions are assigned to a role.
e.g.
GRANT SELECT ON view1 TO user1 WITH GRANT OPTION
from the above example, user1 will be able to grant the SELECT permission on view1 to other users.
HTH
B
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply