Advertisement
Guest User

Untitled

a guest
Sep 25th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. -- in master database
  2. CREATE LOGIN reader WITH password='YourPWD';
  3. -- grant public master access
  4. CREATE USER reader FROM LOGIN reader;
  5.  
  6. -- in target database
  7. CREATE USER reader FROM LOGIN reader;
  8. EXEC sp_addrolemember 'db_datareader', 'reader';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement