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