Specific database administration

[nour]

let say you have 3 different databases with 3 different owners under the same registred SQL server, how do you give privilegees and roles to each user to accomplish all DBA tasks each for its own database:
The tasks include:
Indexes tuning
profile tracing
check of DB integrity
adminitration of users of the DB...etc


P.S: the user A will be able to fully administer only Database DB1 and not able to administer DB2 and DB3 .
Thank you

[rmiao]

Add user to db_owner role in managed db and they can do almost everything in that db. But certain tasks, using index tuning wizard and tracing with profiler for instance, need sysadmin rights.

[nour]

Thanks rmiao

[waberi]

Nour is that an African name??