March 3, 2010 at 10:49 am
Hi,
When i make a restore i can define that the database will be in restricted mode.
I have tryed this and when i went to the database properties, the database is in Restricted_user mode , not in single user mode.
What is the difference between this two restrictions?
Thank you
March 3, 2010 at 10:53 am
Restricted user - only users with dbo rights on database allowed
single user - only one connection allowed, first come, first served
---------------------------------------------------------------------
March 3, 2010 at 11:00 am
thank you george
March 3, 2010 at 11:03 am
If i create a user (SQL User) with a login named Paul and then mapped to the database (user account) with db_owner permissions he will be capable of connection when the database is in this mode (restricted), correct?
I say this, because i think that any login that belongs to the database role DB_owner, connects as dbo, correct?
Thank you
March 3, 2010 at 11:59 am
for authorization, being the actual dbowner or just member of db_owners db group is equal.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 3, 2010 at 4:16 pm
Is there something you are trying to achieve here? Perhaps we have other advice?
ALZDBA is correct, anyone with DB_owner rights can access the db.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply