November 22, 2010 at 11:41 am
i have the requirement to deny the execute permissions on XP's for public role in sql server. i have used the
revoke [object] on to get the tack done.The output gave just command completed successfully. But the where can i see which permissions have been denied for the public role.
i could not see in the properties tab of the public role for denying these XP permissions.
Can any one help me in seeing those
November 23, 2010 at 9:06 am
Try this:
SELECT so.name, user_name(sysperm.grantee) as [Granted To]
FROM master.dbo.sysobjects so JOIN master.dbo.syspermissions sp
on so.id=sp.id
WHERE so.type = 'X'
Order by name
Maninder
www.dbanation.com
November 23, 2010 at 9:48 am
What does sysperm.grantee need to passed. the username or the role
November 23, 2010 at 11:12 am
this is the check and see al permission on the system sp.
Maninder
www.dbanation.com
November 23, 2010 at 11:26 am
This throws an error for me...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply