In my Azure SQL server, I see the SQL login that allows me to connect to the server. However, when I look at the Users defined for my database on that server, I don't see a user account with the same name (which I would expect). How am I able to access my database (which I am able to do), without a database user account?
asked May 27, 2017 at 21:02
-
Is that SQL login is the admin account?– SqlWorldWideMay 27, 2017 at 22:52
-
It could be. It was the account that was created when I created the database.– Randy MinderMay 27, 2017 at 23:45
Add a comment
|
1 Answer
Your login is mapped to different database user, most probably to dbo . You can check this by executing:
SELECT CURRENT_USER
You can also compare the output from following views (and find matching SIDs to figure out login to user mapping):
SELECT * FROM sys.sql_logins -- you need to execute this on master azure db
SELECT * FROM sys.database_principals -- you need to execute this on the database of interest
