August 25, 2009 at 12:04 pm
when I adding a new user to DB1 I get data reader rights by default
then when I go to DB2 it gives me db_owner rights by default, there for i must deselect it each time.
not sure where or how this happens?
thanks
August 25, 2009 at 12:10 pm
What rights does the guest login have in those databases?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 25, 2009 at 12:16 pm
yea.....that is the first place I looked...
you would thing that is the problem.since whatever is in public is by default everywhere else....but no luck
August 25, 2009 at 12:24 pm
What login are you creating the user accounts based on? If the server-level login has certain rights, database-level user accounts will have those rights.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 25, 2009 at 12:38 pm
I am going to server level security. right clicking add new user, sql auth
then when I go to user mapping.
as soon as click on DB1 DB_DATAREADER is selected and public
then on DB2 DB_OWNER and public is selected
not sure if I answered your ?
I also go to DB1 database roles and select DB_READER thinking that public will be selected but its not
then to Public and there is not...does nohing there.....doesnt make since
August 28, 2009 at 7:24 am
I'm not sure what would cause that outside of the public role having those rights.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 28, 2009 at 7:39 am
just out of curiosity, does this happen if you create the login and the user, using t-sql rather than through the gui. and do you have any triggers setup either up at the server level or database level.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply