SQL USER_NAME() windows authentication

When I logged in sql management studio with windows authentication and I run

SELECT USER_NAME()

I see the result as dbo.

I would of thought that it would showed my user ....

I more looking开发者_如何学JAVA at the explaination to as why it returns dbo

Use this instead

SELECT SUSER_NAME()

USER_NAME: Returns a database user name from a specified identification number.

SUSER_NAME: Returns the login identification name of the user.

Try:

SELECT SUSER_SNAME()

i had similar problem, the problem is due to the way user id is created.

choose the login id under security -> right click properties -> Server Roles. Ensure you click only "Public" no "sysadmin"