Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aomamp
Starting Member
2 Posts |
 Posted - 2008-08-26 : 03:05:27
|
| I have more 5000 database when use user login have database role equal to db_datawriter and db_datareader cannot expand database with sql enterprse manager but when use user login have database role equal to system administrator can expand database.remark 1. Windows 2003 Server 64x Ent2 . SQL Server 2000 SP4Please suggest me becuase I want to change user for security model Thank you. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-26 : 09:59:18
|
| If you give user db_datareader and writer permission to specific database, then user will only be able to expand that database. |
 |
|
|
aomamp
Starting Member
2 Posts |
Posted - 2008-08-27 : 00:36:06
|
| May I clearify my post as text below?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. |
|
|
|
|
|
|
Cannot expand many dabase with SQL Enterprise