Re: db_owner

I just created a Windows domain user something like 'DomainAUser\JoeTest'
and assigned him to the db_owner role to one of our user created databases.
When I set up an odbc or .udl using this Windows domain user credentials how
come this user is able to see our system databases and a couple other in the
default database drop down box which kind of is concerning.

Thanks.


"Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26708F07-A4D5-41EB-BDE9-169A201295A4@xxxxxxxxxxxxxxxx
Yes, db_owner will pretty much give the consultant full control but only
within that database.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"zz12" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:e5sNUtgNIHA.5860@xxxxxxxxxxxxxxxxxxxxxxx
Hello. What would be the best role assignment for a temporary consultant
to access one of our user created databases on our sql2k server to allow
this person to develop freely but only within this database and not any
of our other databases including the obvious system databases? Would it
be ok to give this consultant a windows domain login and assign it as a
db_owner or would assigning a combination of the other system roles
within this db be better?

Thanks in advance.




.

Relevant Pages

  • Re: Jumping records
    ... turn can be assigned to many contacts and one job type can be also assigned ... I do use combo boxes as a way of assigning these ... I have built many databases for may users that follow ... It could also be form corruption of course; ...
    (microsoft.public.access.forms)
  • Should i learn Access?
    ... I know very little about databases but need to create ... It would be a relatively simple DB, where employees ... with permissions and assigning them, ...
    (microsoft.public.access.gettingstarted)