Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-06-02 : 01:03:27
|
| From SQL Server, can i see who all the windows users and groups has admin privilege??I tried this one and it is working fine in 2008Xp_logininfo 'Builtin\Administrators',membersaccount name type privilege mapped login name permission pathCSD\u1 group admin CSD\Admins-India Builtin\AdministratorsCSD\Domain Admins group admin CSD\Domain Admins Builtin\AdministratorsCSD\ramesh user admin CSD\ramesh Builtin\AdministratorsSecondly, I used Xp_logininfo account name type privilege mapped login name permission pathCSD\ramesh user admin CSD\ramesh NULLBUILTIN\Administrators group admin BUILTIN\Administrators NULLNT AUTHORITY\NETWORK SERVICE user admin NT AUTHORITY\NETWORK SERVICE NULLNT AUTHORITY\SYSTEM user admin NT AUTHORITY\SYSTEM NULLBut when i tried to use the below command to know who all the members falling in below two groups but am getting an errorXp_logininfo 'NT AUTHORITY\SYSTEM',members goXp_logininfo 'NT AUTHORITY\NETWORK SERVICE',members go/*Msg 15404, Level 16, State 5, Procedure xp_logininfo, Line 42Could not obtain information about Windows NT group/user 'NT AUTHORITY\SYSTEM', error code 0x8ac.Msg 15404, Level 16, State 5, Procedure xp_logininfo, Line 42Could not obtain information about Windows NT group/user 'NT AUTHORITY\NETWORK SERVICE', error code 0x8ac.*/Can anybody figure out why it is saying so?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2010-06-02 : 13:13:11
|
| Thanks Tara! |
 |
|
|
|
|
|
|
|
Xp_logininfo