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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Database user access

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'
Go to Top of Page

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"
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-25 : 16:51:57
or Check in role: DbOwner

Do you see users?
Go to Top of Page

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-02-25 : 17:03:28
quote:
Originally posted by sodeep

or Check in role: DbOwner

Do you see users?


I see that user in db_owner. Thx.
Go to Top of Page

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.
Go to Top of Page

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.
Go to Top of Page

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, role1
For the one which he needs access to: I assigned the follow roles:
public, db_owner, db_datareader.
Thx.
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-02-25 : 17:21:46
Using sql server login
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-25 : 17:42:05
Try with username and password in Query analyzer
Go to Top of Page

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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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!!

Go to Top of Page

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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -