Pau Lo
asked on
SQL Server authentication accounts per instance or per database
Do you have accounts (SQL Authentication) per SQL Server instance or per SQL Server database? I was aware the password hashes are stored in sysxlogins table. But I wasnt sure if there was a sysxlogins table per database, or one per instance? If its per instance, how can you tell what permissions each account has over which database? Can you provide perhaps a query to list out the permissions by SQL authentication accounts.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. But as per the question, is there a set of accounts per database, or per instance. Is there a sysxlogins per database or per instance?
Ideally syslogins table will be available in the master database per instance and will be shared across all user databases and sysusers table will be present in all user databases with individual entries inside it.
ASKER
Do all the later versions of SQL Server still support the mixed mode authentication?
Yes, all SQL Server versions supports Mixed Mode Authentication..
http://www.mssqltips.com/sqlservertip/1071/auditing-your-sql-server-database-and-server-permissions/