Managing Security, Login and User in SQL Server
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Server?
✍: FYIcenter.com
Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team
on Managing Security, Login and User in SQL Server.
Clear answers are provided with tutorial exercises on security
model; security principals, securables and permissions; creating,
changing and dropping login names; linking users with logins.
Security Model Used in SQL Server 2005 in SQL Server
Security Principals Used in SQL Server 2005 in SQL Server
Suser_Sname() - Sever Level Security Principal of Your Session in SQL Server
User_Name() - Database Level Security Principal of Your Session in SQL Server
"CREATE LOGIN" - Creating a New Login Name in SQL Server
Verifying a Login Name with SQLCMD Tool in SQL Server
sys.server_principals - Listing All Login Names in SQL Server
"ALTER LOGIN" - Changing the Password of a Login Name in SQL Server
"ALTER LOGIN" - Changing a Login Name in SQL Server
"ALTER LOGIN" - Disabling a Login Name in SQL Server
"DROP LOGIN" - Deleting a Login Name in SQL Server
"CREATE USER" - Creating a User Name in a Database in SQL Server
sys.database_principals - Listing All User Names in SQL Server
Finding the Login Name Linked to a Given User Name in SQL Server
Verifying a User Name with SQLCMD Tool in SQL Server
"ALTER USER" - Changing the Name of a Database User in SQL Server
2016-10-20, 385👍, 0💬