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, 1418🔥, 0💬
Popular Posts:
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...