When I log in sql management studio with windows authentication and I run
SELECT USER_NAME()
I see the result as dbo.
I expected it would show my user.
I am looking for an explanation as to 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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With