SQL Server Performance Forum – Threads Archive

Login Name

Hi, How can I get the Login Name of a Windows Authenticated ID? It always generate an output of dbo…

Try SELECT SYSTEM_USER
Roji. P. Thomas
SQL Server MVP
http://toponewithties.blogspot.com

also check sys.server_principals catalog view and Security Catalog Views in BOL Madhu

Using "System_user" will only get the current user login using windows authenticated.. But how can I get the other login names of windows authenticated ID’s not currently login but have provilege on some database?

Check sp_helplogins procedure…for object level permissions sp_helprotect proc. select * from sys.syslogins
MohammedU.
Moderator
SQL-Server-Performance.com

http://www.sql-server-performance.com/faq/viewfaq.aspx?faqid=195 too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

]]>