Managing Security, Login and User in SQL Server

Q

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Server?

✍: FYIcenter.com

A

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

"DROP USER" - Deleting a Database User in SQL Server

 

Security Model Used in SQL Server 2005 in SQL Server

"DROP SCHEMA" - Dropping an Existing Schema in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-20, 2948👍, 0💬