August 17, 2006 at 2:05 pm
Is there an easy way using EM in 2005 to see on what stored procedures a user has execute permissions? ( I know in 2000 you could do this: in EM: DB --> Users --> Double-click on a user --> select 'Permissions' ) Is there an equivalent process in 2005?
August 17, 2006 at 4:29 pm
I've been using 2005 since before the official release and its one of the few things about SSMS that I do not like. From within the managment studio there seems to be no easy way to view what permissions a user has. As far as I am waware the only thing you can do is use a query similar to the following adapted to your needs
SELECT
pm.permission_name,
pm
.state_desc,
pr
.name,
pr
.type_desc,
o
.name,
o
.type_desc
FROM
sys.database_permissions pm
INNER JOIN
sys.database_principals pr
ON pm.grantee_principal_id = pr.principal_id
INNER JOIN
sys.objects o
ON pm.major_id = o.object_id
WHERE
pr.name = 'username'
ORDER
BY pr.name, pm.state_desc;
hth
David
August 18, 2006 at 7:06 am
Thank you -- I can modify this to get what I need. Maybe MS will add the old functionality back in?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply