Windows Authentication USER_NAME ()

Question

When I entered the sql management studio with windows authentication and I ran

SELECT USER_NAME()

I see the result as dbo.

I thought it would show my user ....

I look more at the explanation why it returns dbo

Answer 1

Use this instead

SELECT SUSER_NAME()

USER_NAME : returns the database username from the specified identification number.

SUSER_NAME : returns the username for the login.

Answer 2

Try:

SELECT SUSER_SNAME ()

Answer 3

, , .

→ → . , "Public" no "sysadmin"