Post reply

Read Only DB

  • November 5, 2008 at 6:40 pm

    #127557

    What is the easiest approach to add a user for read -only DB in sql 2005. I know we can alter DB to read/write and can add but is there any other easy way because even after adding user the DB will be in read-only DB.

    thanks

  • November 5, 2008 at 8:39 pm

    #894642

    If you grant access your database using windows groups instead of users, all you would need to do is add the user to the relevant group and you would not need to make any changes to the database.

    Initially, you need to add the group(s) to the server, grant it access to the database and any tables/view/sprocs and once you have done that, you shouldn't need to make the database write-able any more.

  • November 5, 2008 at 8:41 pm

    #894644

    I tried but it says db is read-only and cannot do it. I dont think tht works, there shud be some other go.

  • November 6, 2008 at 5:32 am

    #894776

    is this a rare issue?

  • November 6, 2008 at 3:37 pm

    #895258

    I too faced this issue.But we had only one database in that server.So I gave sysadmin to that login instead of mapping a user to that database.It worked for our scenario.Since its readonly DB he cant do any changes ,even with sysadmin rights.(he can drop the DB:))....

Viewing 5 posts - 1 through 4 (of 4 total)

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