Post reply

Cannot expand many dabase with SQL Enterprise Manager

  • August 26, 2008 at 12:38 am

    #72911

    One of my SQLServer2000 host has database around 5000 databases. When i register this SQL host in Enterprise Manager MMC using an account with System Administrator server role (like sa), I can list all databases in the host. However, it take long time.

    The problem is when i register this SQL host in EM MMC using account with non-System Administrator server role, I can't list any databases and EM console not response (hang). I already have many tries to wait for 1 - 2 hours but EM still hang. The non-SA account I use have access to all databases in the host as db_reader and db_writer. I require non-SA account to work on EM console for security reason.

    Please give me some advise.

  • August 26, 2008 at 6:12 am

    #863046

    Server role dbcreator grants a user the ability to create, alter, and drop databases. This would give them access to modify any database on the server.

    Database roles db_owner and db_ddladmin would give a user the ability to alter just the current database. They do come with a number of other permissions as well so you might want to check them out in BOL.

    _____________________________________________________________________
    - Nate

    @nate_hughes

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

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