CURRENT_USER always returns dbo? 1

[DatabaseDude]

I have SQL Server set up for logins via Windows authentication and "use trusted connection."

However, CURRENT_USER always returns 'dbo' rather than the person's true login name.

Any way to capture that value? Something differently I should be doing with connection string?

 

[SQLDenis]

use select suser_sname()

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[DatabaseDude]

Cool, good to know that

That returns domain and username (example: 'ABC\myusername').

The login was added to the database as just the username with sp_grantdbaccess.

EXEC sp_grantdbaccess 'ABC\myusername', 'myusername'

Is there a related way of returning just 'myusername' rather than 'ABC\myusername'?

Thanks, really appreciate your help

 

[SQLDenis]

One way

SELECT substring(suser_sname(),
CHARINDEX('\', suser_sname() )+1,
len(suser_sname())-CHARINDEX('\', suser_sname()))

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[DatabaseDude]

I knew that trick, just wasn't aware of there maybe being something built-in to do it directly.

You're much appreciated