Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Stone Yen 34 posts 55 karma points
    Dec 14, 2009 @ 04:00
    Stone Yen
    0

    About the db_owner role

    Umbraco: 4.0.2.1

    ASP.NET: 3.5

    Windows and IIS: Win 2003/ IIS6.0

     

    Is it possible to revoke the db_owner permission after installed the Umbraco?

    Due to company security policy, the database account used by the application cannot be the db_owner.

    Thank you.

    Copy Link
  • Dirk De Grave 4541 posts 6021 karma points MVP 3x admin c-trib
    Dec 14, 2009 @ 08:52
    Dirk De Grave
    0

    I think you can revoke the db_owner permission, as long as the account used still has db_reader/db_writer permissions. Please do check first. At least it won't hurt your system to revoke the permission

     

    Hope this helps.

    Regards,

    /Dirk

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Dec 14, 2009 @ 08:53
    Richard Soeteman
    0

    Hi,

    That should be possible. DB Owner is only needed during install because it needs to create tables. After that it's not needed, 1 remark. If you install a package that wants to create tables into the database (such as Uforum) you need DB owner rights again.

    Cheers,

    Richard

    Copy Link
  • Laurence Gillian 600 posts 1219 karma points
    Feb 28, 2011 @ 18:51
    Laurence Gillian
    0

    I can't find the original forum post in question, but as mentioned above here, upgrading from 4.0.x to 4.6.x fails if the database does not have 'DB Owner' rights.

    The installer will just hang at 35%.

    It seems a few people are having this problem. So just ping on this post as an heads up! Lx 

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft