Collections:
"CREATE USER" - Creating a User Name in a Database in SQL Server
How To Create a User Name in a Database in SQL Server?
✍: FYIcenter.com
User names are security principals at the database level. If you want to allow a login name to access a specific database, you need to create a user name in that database and link it to the login name.
Creating a user name can be done by using the "CREATE USER" statement as shown in this tutorial exercise:
-- Login with "sa" -- Create a login CREATE LOGIN Fyi_Login WITH PASSWORD = 'IYF' GO -- Select a database USE FyiCenterData; GO -- Create a user and link it to a login CREATE USER Fyi_User FOR LOGIN Fyi_Login; GO
Login name "Fyi_Login" should be able to access database "FyiCenterData" through user name "Fyi_User".
⇒ sys.database_principals - Listing All User Names in SQL Server
⇐ "DROP LOGIN" - Deleting a Login Name in SQL Server
2016-10-19, 1137👍, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...