Post reply

Database Reader Permission

  • October 6, 2008 at 10:48 pm

    #199313

    We have nearly more than 100 user DB's in a Server in 2005.

    I wanted to give Datareader permission to all most of the DB's using Query.

    We have nearly more than 40 logins in this server.

    Plz tell me a procedure to give Data_reader permission.

    I tried this , but not working

    EXEC sp_addrolemember 'db_datareader', 'Username'

    Please give me a solution for me to perform task easier.

    Thanks for all those answering.

  • October 7, 2008 at 2:49 pm

    #881983

    It would be easier to offer advice if you post what happened when you executed sp_addrolmember. I'm going to guess you got an message that said something like, "User 'Username' doesnot exist in this database". A login has to be granted access to a database before it can be a member of a fixed database role.

    Greg

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

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