Post reply

Deny Access to a Database

  • January 9, 2008 at 4:14 am

    #185265

    I'm looking for some help please...

    We have one production server that hosts multiple databases, we have a three sysadmin users on this server to help administrate it. However there is now a requirement to build a database that needs restrictive access to just one dba.

    So the question is; is there anyway of stopping the people with sysadmin access from accessing this database i.e. deny access to a database?

    PS we are running on a SQL Server 2000 standard edition server.

    Any help would be great.

  • January 9, 2008 at 4:27 am

    #766091

    I don't see any besides creating separate instance of server for that database.

    ...and your only reply is slàinte mhath

  • January 9, 2008 at 5:31 am

    #766112

    Sysadmin can perform any activity in the sql server installation hence it's not possible.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • January 9, 2008 at 6:40 am

    #766132

    You could set some things up, like DDL triggers, but a sysadmin could disable them.

    Remove them from sysadmin access if you need to.

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

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