User creation

[vaidyanathanpc]

Hi,
I am not know how to give access to a user as per the scenario below.

I have a server (say Server1). I have put my database (DB1) on Server1. Now there is one more database (DB2)which is also going to sit on Server1. I want to create a user (login) who can do whatever he wants (backup,restore, create users, assign privileges etc on the DB2 database) but he should not be able to access the DB1 database. I'm logged in with sa privileges.

How can I achieve this??
Would be glad if you could send me the steps to achieve this.

Thanks
P.C. Vaidyanathan

 

[tlbroadbent]

1) Don't grant the user access to DB1.

2) Grant the user access to DB2 and add the user to the DB_OWNER role in DB2. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.