Post reply

dbo access

  • May 9, 2004 at 7:42 pm

    #102001

    Is there a way to restrict dbo access to a db in SQLServer 2000? I have a database that I need to allow a couple users with admin rights to sensitive information.

    Thanks

    Bruce

  • May 10, 2004 at 4:36 am

    #505762

    admin in database is dbo. No to the question.

    One way for limited access is Encryption.

  • May 10, 2004 at 4:32 pm

    #505877

    thanks

  • May 11, 2004 at 7:57 am

    #505969

    There are many options you can set to modify the behavior of a database. These options are grouped in different categories. There is an option in the “Database STATE” category that will enable to restrict database access to database owners (db_owner), database creators (db_creator) and system administrators (sysadmin) fixed server roles.  Database options can be establish in two ways:

    • By using the SET clause of the ALTER DATABASE statement (sp_dboption stored procedure) and
    • By using SQL Server Enterprise Manager.

    Following are the Enterprise Manager steps you need to follow in order to accomplish your requirement:

    1. Expand your server group, and then expand your server.
    2. Expand Databases, right-click the database to change, and then click Properties.
    3. Click the Options tab, and select Restrict Access

    Note: See Setting Database options in BOL

  • May 11, 2004 at 5:04 pm

    #506060

    thanks, but setting options wont allow me to restrict some dbo's and allow others access. 

    I'm trying to find out about encryption.

    Bruce

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

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