Pedro Lopes 5c23f3764f New uploaded solution 9 anni fa
..
README.md 6b70c7a722 Updated Readme 9 anni fa
usp_SecurCreation.sql 5c23f3764f New uploaded solution 9 anni fa

README.md

Change log and other information available at http://aka.ms/SQLInsights - SQL Swiss Army Knife Series

Purpose: Generates all database logins and their respective securables.

These are the options available:

  • All users: EXEC usp_SecurCreation
  • One user, All DBs: EXEC usp_SecurCreation ''
  • One user, One DB: EXEC usp_SecurCreation '', ''
  • All users, One DB: EXEC usp_SecurCreation NULL, ''
  • Note: Does not deal with CERTIFICATE_MAPPED_LOGIN and ASYMMETRIC_KEY_MAPPED_LOGIN types.