TSQL and listing of user rights
-
Hi,
Does any body know how to list user rights to databases in TSQL, or how to get a list of databases on which user has rights to....
or something like that?
Is there any procedure or table ? Any hints?
Thanks
-=mrdoc=-
-
Start with sp_who and sp_who2. Try the link below for more info. Hope this helps.
http://www.mssqlcity.com/FAQ/Admin/current_users.htm
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie -
sp_who gives information about currently active users. If you want to get some info about user permissions, a better place to start would be undocumented procedure sp_MSobjectprivs. I have no experience with it myself, just know that it is there and is used when you display permissions in EM.
As it is undocumented, you'll probably have to search the web to find out how it works or how it can be used.
HTH, Vladan
-
I've used this utility that I found in an article on this site:
http://www.sqlservercentral.com/columnists/cmiller/dumpsqlpermissions.asp
It works quite well
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
Thanks to Yours hints I found intofmation about sysprotects table.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-p_0837.asp
I think that 'll help me
Thanks once again
Regards
AG
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply