Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- use mydb
- go
- exec sp_addrolemember db_datareader, MYUSER
- go
- exec sp_addrolemember db_datawriter , MYUSER
- go
- GRANT EXECUTE to MYUSER ; /* Grant to all store procs */
- GO
- GRANT EXECUTE ON USP_LOADSOMEDATA TO MYUSER; /* Grant to as specific store procs */
Add Comment
Please, Sign In to add comment