This is for MS SQL2000
How Can I limit acces to <test> database and still have admin rights to create backups and table and modify table structures only that <test> database.
A consultant will be accessing database on database server using enterprise manager from client tools installed on terminal server.
I would like to just limit the access only to this <test> database. No other database should be accessible. They require administrative rights on this database.