Contained User within a Non-Contained Azure SQL Database
0
votes
1
answer
654
views
While granting access to Azure SQL databases I have been creating Contained Users directly in the SQL database like so:-
CREATE USER [email@domain.com] FROM EXTERNAL PROVIDER;
As this has been working fine, and users need to add the database name to the connection, I thought azure would know this is now a contained database.
However, upon checking, I've found the database is not contained
select containment, containment_desc from sys.databases
containment / containment_desc
0 / NONE
0 / NONE
Should I now convert the database to be contained?
Are there any implications for leaving the database in this state?
Should I revert back to creating the user at both the server and DB level?
Asked by Porkster
(132 rep)
Jan 31, 2019, 11:51 AM
Last activity: Jan 31, 2019, 12:36 PM
Last activity: Jan 31, 2019, 12:36 PM