Re-generating SQL Server Logins
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Tue, 08 Feb 2011 07:00:00 UT
Indexed on
2011/02/08
23:32 UTC
Read the original article
Hit count: 281
Filed under:
SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.
The Future of SQL Server Monitoring "Being web-based, SQL Monitor 2.0 enables you to check on your servers from almost any location" Jonathan Allen. Try SQL Monitor now. |
© SQL Server Central or respective owner