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, 3147🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...