Re: db_owner

Thanks for your speedy confirmation Dan. Much appreciated :-)


"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: corrupt msdb
    ... > collation than the other system databases. ... > Tibor Karaszi, SQL Server MVP ... > "Jacco Schalkwijk" wrote in message ... rename the msdb data and log files and put ...
    (microsoft.public.sqlserver.server)
  • Re: Database files are "Hidden" after becoming Suspect
    ... Mike Epprecht, Microsoft SQL Server MVP ... > We had created some databases on the C Drive. ... > datafile the data file was not showing up. ...
    (microsoft.public.sqlserver.server)
  • Re: i cannot start sqlservers service
    ... > restore backup of the master ... >> and msdb databases. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Unable to upgrade SQL 2000 Evaluation to SQL 2000 retail version
    ... there) and restore that on your new installation. ... "Lazaros Lazarou" wrote in message ... >> install Standard Edition and re-attach your databases. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: sp_track_db_growth
    ... SQL Server MVP ... > I have added the above listed stored procedure to a number of my servers ... > have been able t use it quite successfully on most databases. ... > Arithmetic overflow error converting numeric to data type numeric. ...
    (microsoft.public.sqlserver.server)