Post reply

How to create a readonly user

  • November 24, 2009 at 3:08 am

    #228168

    Hi

    I have been asked to create a user with readonly access to all databases on a particular server but am not sure how to achieve this?

    I know I can create a user and then map that user to the db_datareader role for each database but how can I automate this?

    Also, how can I make sure that when new dbs are added, this user has read access to them also or is this something I must administer each time?

    btw, i'm pretty new to mssql as you have probably guessed.

    Many thanks

    Farren Minns

  • November 24, 2009 at 3:39 am

    #1083345

    Farren,

    There is no such server level read only user to my knowledge. But you may try using DDL trigger to achieve this. Please consider performance security implication of doing this.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • November 24, 2009 at 3:42 am

    #1083348

    Thanks Joe

    At least I wasn't missing something obvious.

    Regards

    Farren

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

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