| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-02-25 : 16:39:31
|
| I just added a user as a db_owner in a database, but the user is unable to access the db. Thanks!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-25 : 16:48:42
|
| Is it in production of development?check this out:sp_helpuser 'db_owner' |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-25 : 16:49:14
|
Did you relate the user as an owner for a particular database too?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-25 : 16:51:57
|
| or Check in role: DbOwnerDo you see users? |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-02-25 : 17:03:28
|
quote:
Originally posted by sodeep
or Check in role: DbOwnerDo you see users?
I see that user in db_owner. Thx. |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-02-25 : 17:03:51
|
quote:
Originally posted by sodeep
Is it in production of development?check this out:sp_helpuser 'db_owner'
It's Prod. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-25 : 17:04:53
|
| Then why want to give user DB_owner. He can do anything with database. |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-02-25 : 17:08:58
|
quote:
Originally posted by Peso
Did you relate the user as an owner for a particular database too?
E 12°55'05.25"N 56°04'39.16"
For one of the prod db: his role was public, role1For the one which he needs access to: I assigned the follow roles:public, db_owner, db_datareader.Thx. |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-02-25 : 17:10:59
|
quote:
Originally posted by sodeep
Then why want to give user DB_owner. He can do anything with database.
Initially gave db_datareader, since that did'nt work, I wanted to try with db_owner, unfortunately even that's not working. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-25 : 17:15:16
|
| Thats funny. Don't try in Production Server. Google server role and Database roles for information .Are you using Windows login or SQL server login |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-02-25 : 17:21:46
|
| Using sql server login |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-25 : 17:42:05
|
| Try with username and password in Query analyzer |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-25 : 17:55:54
|
| It always helps to post the error since we can't read your mind.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-02-25 : 18:03:47
|
quote:
Originally posted by tkizer
It always helps to post the error since we can't read your mind.
When I learn that trick (mind reader), I won't be doing this gig anymore...I'll be doing three shows a day in Vegas. ;)Does the login even have access to the database? Sounds like it may not from...quote:
sqlserverdeveloper: I just added a user as a db_owner in a database, but the user is unable to access the db. Thanks!!
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-25 : 18:18:07
|
| How can you add a user to the db_owner database role if the login doesn't have access to the database?We really need to see the error in order to make any conclusions.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
Database user access