December 26, 2003 at 10:48 am
Would anyone be so kind as to demonstrate how to query for the effective permissions of a SQL user. I also would like to grant execute permissions on stored procedures within a specific database.
Any help is appreciated.
Thanks
December 26, 2003 at 11:30 am
Don't grant to users, use roles.
That being said, the permissions matrix is by user/role by object, so you'd probably want to query for a specific object to see the permissions. In EM you can query the permissions for a specific object and then see the users/roles with permissions.
to gratn permissions
GRANT EXECUTE ON <proc name> to <role/user>
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply