code_junkie

TSQL to grant db_datareader and db_datawriter for MS SQL Server

Nov 13th, 2011
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. use mydb
  2. go
  3.  
  4. exec sp_addrolemember db_datareader, MYUSER
  5. go
  6. exec sp_addrolemember db_datawriter , MYUSER
  7. go
  8.  
  9. GRANT EXECUTE to MYUSER ; /* Grant to all store procs */
  10. GO
  11. GRANT EXECUTE ON USP_LOADSOMEDATA TO MYUSER; /* Grant to as specific store procs */
Add Comment
Please, Sign In to add comment