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 |
|
ramesh
Starting Member
2 Posts |
 Posted - 2002-12-31 : 02:47:44
|
| a user who has a sql server login named bob requires access to the customer db and financial db.DBA creates a user in the customer db using bobs sql server login and grants that db user whatever permissions are necessary to perform his duties.Why does Bob not have access to financial DB? |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-31 : 02:53:02
|
quote:
a user who has a sql server login named bob requires access to the customer db and financial db.DBA creates a user in the customer db using bobs sql server login and grants that db user whatever permissions are necessary to perform his duties.Why does Bob not have access to financial DB?
you will have to create a user for the financial db and give him the required permissions in that database so that he can access the financial DB.Expect the UnExpected |
 |
|
|
ramesh
Starting Member
2 Posts |
Posted - 2002-12-31 : 02:59:19
|
quote:
a user who has a sql server login named bob requires access to the customer db and financial db.DBA creates a user in the customer db using bobs sql server login and grants that db user whatever permissions are necessary to perform his duties.Why does Bob not have access to financial DB?
But i would like to know if we have a user who can access finance db is there any way to map bobs login to that userThank you Harshal. |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-31 : 03:06:26
|
quote:
quote:
a user who has a sql server login named bob requires access to the customer db and financial db.DBA creates a user in the customer db using bobs sql server login and grants that db user whatever permissions are necessary to perform his duties.Why does Bob not have access to financial DB?
But i would like to know if we have a user who can access finance db is there any way to map bobs login to that userThank you Harshal.
yes you can use sp_addalias in sql 7 I am not sure if it is supported in sql 2k.check BOL under the topic mapping login information.regards,Happy New Year!harshal.Expect the UnExpected |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-31 : 12:28:58
|
| This sounds too much like a homework question. |
|
|
|
|
|
|
user accounts help