Post reply

sysadmin type access without update capability?

  • August 20, 2004 at 9:21 am

    #164714

    We have a situation where we require a user to see anything and everything in a SQL server instance (properties, log files, all databases and objects, jobs, etc.), however, we don't want that user to be able to make any changes to anything.

    Is that possible?

     

  • August 20, 2004 at 10:04 am

    #520016

    I think (someone else jump in here) that if you create the userid in SQL and give them db_DataReader & db_DenyDataWriter and don't give them any other roles/permissions it should work.

    But then I'm not a total SQL Server Security guru either.



    ----------------
    Jim P.

    A little bit of this and a little byte of that can cause bloatware.

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

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