Re: db_owner

From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 5 Dec 2007 20:23:37 -0600

All logins can access databases with the guest user enabled. This includes sample and system databases but permissions in the system databases are minimal.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"zz12" <IDontLikeSpam@xxxxxxxxxxx> wrote in message news:O0%23a8Y5NIHA.3852@xxxxxxxxxxxxxxxxxxxxxxx

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.

Follow-Ups:
- Re: db_owner
  - From: zz12

References:
- db_owner
  - From: zz12
- Re: db_owner
  - From: zz12

Prev by Date: Re: db_owner
Next by Date: Re: How to genericaly search the entire db for any text string in any stored procedure, function, table definition, agent job, etc. Any one command or anyone have a stored proc that does this wide search?
Previous by thread: Re: db_owner
Next by thread: Re: db_owner
Index(es):
- Date
- Thread

Relevant Pages

RE: Moving SQL Server 2000 to a new machine
... In addition to all the CYA advise, you CAN move the system databases. ... Once you've got the new server at SQL2K, SP2, and the physical paths to ... > Recently I was tasked to move our entire SQL Server 2000 to a new server. ...
(microsoft.public.sqlserver.server)
Re: select from one db only
... No.He can see those system databases and sample databases because its common ... databases.You can however DENY permissions.For example, ... "Doug" wrote in message ...
(microsoft.public.sqlserver.security)
Re: Move databases between servers
... I assume we can backup the system databases (including ... then restore the system databases. ... When you restore databases on your other server SQL Server adds ...
(microsoft.public.sqlserver.setup)
Re: Server Rebuild - What to do?
... but as a backup procedure perform a full database backup for ... all databases including system databases before you do any thing. ... COpy the MDF and LDF to a safe location including system databases ... Install SQL Server in same path ...
(microsoft.public.sqlserver.setup)
Re: Server Rebuild - What to do?
... but as a backup procedure perform a full database backup for ... all databases including system databases before you do any thing. ... COpy the MDF and LDF to a safe location including system databases ... Install SQL Server in same path ...
(microsoft.public.sqlserver.setup)