Post reply

Enterprise Manager in READ ONLY mode ?

  • February 8, 2006 at 11:22 am

    #152745

    Is it possible to give a user access to Enterprise Manager (and Analysis Services Manager) in READ ONLY mode?

    I can't find any info on this. Possible? How?

  • February 8, 2006 at 11:31 am

    #619592

    If the user has read-only access to the database(s) they will have read-only permissions regardless of the tool they use to connect.

     

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • February 9, 2006 at 9:57 am

    #619846

    After you add the login for the user make that user member of the db_datareader role for the dbs that he/she needs to read.  Like the previous post regardless of the tool user uses to connect, he/she will only be able to read.

  • February 10, 2006 at 3:06 am

    #620049

    thanks guys.

     

    any ideas for analysis (services) manager?

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

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