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 |
|
vaidyanathanpc
Starting Member
24 Posts |
 Posted - 2002-06-14 : 07:05:27
|
| 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.ThanksP.C. Vaidyanathan |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-14 : 07:48:45
|
| What have you tried so far that didn't work? Have you read the Books on Line chapter about managing Security?<O> |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-06-14 : 09:34:26
|
| Page47 is right -- read BOL! Before you start managing security you need to at least understand the difference between server logins and database users. To address your question though, here are the steps:1. create a server login 2. create a database user, mapped to this login in DB23. assign the database user you created to the db_owner role in DB2 |
|
|
|
|
|
|
User creation