Sample Header Ad - 728x90

Azure SQL Database - contained users password

2 votes
1 answer
1416 views
Where is the password saved when creating a contained user for the Azure SQL database (PaaS)? For example: CREATE USER taiobtest WITH password='PVHz3U4A$LNytQF^'; GO For server logins I can get it from sys.sql_logins:password_hash column. My use case is refreshing non-production from production backup. I need to script out the database contained users and all relevant permission before the restoration. Once restored clean up production database users/permission and reinstate non-production users and permissions.
Asked by SqlWorldWide (13707 rep)
May 9, 2022, 05:33 PM
Last activity: May 10, 2022, 12:27 PM