Post reply

system schemas owned by user

  • August 14, 2012 at 10:28 am

    #280259

    Hello,

    In one of our databases, the following schemas are showing as owned by a regular user:

    db_datareader

    db_denydatawriter

    db_owner

    the other schemas though, like db_ddladmin, is owned by itself -- ddlamin.

    can i simply change the schemas listed above to be owned by itself? meaning, db_datareader will be owned by db_datareader?

    thank you

  • August 14, 2012 at 10:36 am

    #1525650

    I think so. Test it first on a backup, but all of my schemas like that are owned by themselves.

  • August 15, 2012 at 1:05 pm

    #1526186

    yes, i tested it first, and then implemented it in production -- haven't heard any issues [yet].

    thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply