August 26, 2008 at 12:38 am
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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply