Sunday, March 25, 2012

db_owner can't bring DB online

Is there a way to allow a db_owner to bring his database online without maki
ng him a SA?The Fixed Server Role db_creator will do the trick.
A login with the db_creator role will be allowed is online and offline a DB,
so long as they have a user for the DB. Not sure about the "guest/public" d
b user, because we never keep it|||Please don't repost the same question at one hour intervals. Give the
newsgroup readers a little more time to respond. This was already answered
in your earlier thread.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Ajanti" <anonymous@.discussions.microsoft.com> wrote in message
news:D13F60E9-317C-4AEA-9B43-1F7794A2DB9F@.microsoft.com...
> Is there a way to allow a db_owner to bring his database online without
making him a SA?

No comments:

Post a Comment