Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- in master database
- CREATE LOGIN reader WITH password='YourPWD';
- -- grant public master access
- CREATE USER reader FROM LOGIN reader;
- -- in target database
- CREATE USER reader FROM LOGIN reader;
- EXEC sp_addrolemember 'db_datareader', 'reader';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement