I have an Azure dB server that contains a login name [xUser] in the Master dB. I need to grant this account on another database, so I can set up grants for stored procedures using that account. However, when I try to create the user on the new db
CREATE USER xUser FROM LOGIN xUser;
I get this error:
**Msg 15007, Level 16, State 1, Line 1
'xUser' is not a valid login or you do not have permission.**
Needless to say, the 'xUser' account is the admin account for this Azure setup, and I'm logged in with that account, so I'm sort of confused as to how I wouldn't have permission to add the user to the database.
I've referenced these sites to make my attempts:
I can't see any way in Azure to actually see the users in the masterdB, unless I connect to the database through SSMS - which in turn doesn't allow me the ability to see properties on the users, or do anything with them (They become unclickable items in the Object Explorer).
All I want to do is take [xUser] that is in the master dB, and assign it read/write/execute in my actual data dB.