Advertisement
Guest User

Untitled

a guest
Oct 14th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.26 KB | None | 0 0
  1. CREATE ROLE new_role
  2.  
  3. CREATE USER new_user FOR LOGIN new_user
  4.  
  5. sp_addrolemember [ @rolename = ] 'new_role',  
  6.     [ @membername = ] 'new_user'  
  7.  
  8. REVOKE INSERT ON OBJECT::Test.TestTable FROM 'new_role';
  9. GRANT SELECT ON OBJECT::Test.TestTable FROM 'new_role';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement