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"
精彩评论