Tuesday, March 13, 2018

Login users

Here is the the admin and security code for SQL Server that we did in class

Create Login managerLogin 
with password='password'

use Vincents
Create user ManagerUser 
For login managerLogin

Create role managementRole
Grant Select, insert, update 
on Album to managementRole
Grant Select, insert, update 
on Inventory to managementRole

Alter role managementRole 
add member ManagerUser

No comments:

Post a Comment