You need to enable a new employee to authenticate to your database.
Which command should you use?
You need to enable a new employee to authenticate to your database.
Which command should you use?
To enable a new employee to authenticate to your database, you need to create a new user account for them. The correct SQL command for this purpose is 'CREATE USER'. This command defines a new user in the database system, allowing the new employee to log in and access the database as per the permissions granted.
The CREATE USER statement creates a database user to log into SQL Server. A database user is mapped to a Login, which is an identity used to connect to a SQL Server instance. CREATE USER user_name FOR LOGIN login_name;
CREATE USER: See: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-ver15
B) CREATE USER