--see who the employees are Select * From Person p inner join Employee e on p.PersonKey = e.PersonKey --new login Create Login TinaMoon with password='password' --if you had not already created it Create schema EmployeeSchema --user for CommunityAssist Create user TinaMoon for Login TinaMoon --new role Create role HumanResourcesRole --Permission for the role Grant select, insert, update on Employee to HumanResourcesRole Grant select, insert, update on Person To HumanResourcesRole Grant select, insert, update on PersonAddress to HumanResourcesRole Grant Select, insert, update on PersonContact to HumanResourcesRole Grant exec on usp_newDonation to HumanResourcesRole Grant select on Schema::EmployeeSchema to HumanResourcesRole --add use to the role exec sp_addrolemember 'HumanResourcesRole','TinaMoon'
Thursday, July 16, 2015
SQL For Security
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment