creating a "read only" login/user

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Farhad-138839 SSC Enthusiast Points: 115 More actions · Answer 1

Follow this:

EM -> Security -> Logins -> R-Click -> NewLogin -> Database Access tab

Choose your databases that you want to grant READ ONLY access by check infront of it.

And for each databse, you have to check db_datareader at the below pane.

And you are done!

This is simple to undrestand but you can find more about it in BOL. To start, you can search sp_addlogin.

Canada DBA,

Burt Jacobs SSC Journeyman Points: 79 More actions · Answer 2

SSC Journeyman

Points: 79

August 12, 2004 at 11:26 am

You are correct, sir.

Thank you very much.

Burt