July 10, 2009 at 12:57 pm
Hi
I want to extract all kind of permission granted to a particular windows user in each DB. Can some one pls post the script to extract the user permission?
Thanks
July 10, 2009 at 1:23 pm
Have you just tried selecting from dbo.sysusers?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 10, 2009 at 3:55 pm
Thanks for both of you.
Sysuser holds only User and Role detail but not the object level permissions. I have used sysprotects table to extract the info. The above URL too helped.
July 29, 2009 at 2:35 pm
Can you post the script that you created?
MJ
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply