Contained Database Users hash password

Question

Post reply

Contained Database Users hash password

PatLap

Mr or Mrs. 500

Points: 543
More actions
May 15, 2014 at 10:21 am

#288919

Hi,
Does anybody know where is located the hash password for the contained database users?
I have a script that prints all creating statement so that a Dev environment security can be reapply after a prod data refresh but I can't find the table containing the hash password when the user is "with login" for contained database.
Any guess?
Thank you
Patrick

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

lkennedy76 SSChampion Points: 13683 More actions · Answer 1

select * from sys.syslogins

in master database on the server that the login is on.

MCSE SQL Server 2012\2014\2016

PatLap Mr or Mrs. 500 Points: 543 More actions · Answer 2

lkennedy76,

If it's a contained database there will not be any login therefore no entry in syslogins at the server level.

It has to be at table or view inside the database itself.

Patrick

lkennedy76 SSChampion Points: 13683 More actions · Answer 3

I loath contained DB's. Sorry I was not much help.

MCSE SQL Server 2012\2014\2016

lkennedy76 SSChampion Points: 13683 More actions · Answer 4

I did some digging on this and found this article. Look under Database Boundary and you should find your answer. It basically says that it creates its own system tables in a database model that houses sys tables, they are probably hidden so I would open a query and see what happens, I would have already done this but I do not have any contained DB's or a dev area to test this out.. I hope this helps, Good Luck.

http://msdn.microsoft.com/en-us/library/ff929071.aspx

Database Boundary

Because partially contained databases separate the database functionality from those of the instance, there is a clearly defined line between these two elements called the database boundary.

Inside of the database boundary is the database model, where the databases are developed and managed. Examples of entities located inside of the database include, system tables like sys.tables, contained database users with passwords, and user tables in the current database referenced by a two-part name.

Outside of the database boundary is the management model, which pertains to instance-level functions and management. Examples of entities located outside of the database boundary include, system tables like sys.endpoints, users mapped to logins, and user tables in another database referenced by a three-part-name.

MCSE SQL Server 2012\2014\2016