Options

User account setting ignored in package

obergmanobergman Posts: 5
edited July 4, 2005 7:41AM in SQL Packager Previous Versions
Hi,
My database has one user account with the "db_owner" role. This information is ignored in the db package. What am I missing here?

Thank you,
Morten Bergman
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Morten,

    This depends. If it is an upgrade package, and the user exists in both databases with the same role membership, the user will not be scripted.

    On the other hand, if the package is a new database package, the only possible explanation that comes to mind is the SQL schema option 'ignore users' or 'ignore roles' being set.
    · Share on Twitter
  • Options
    obergmanobergman Posts: 5
    How can I set the 'ignore roles' option? I have version 1.1.2.5 and there is no 'ignore users' or 'ignore roles' options in the "SQL Packager Option" window.
    · Share on Twitter
  • Options
    Daniel HandleyDaniel Handley Posts: 214
    Hi Morten

    What you are looking for is to uncheck the users and roles in the list of objects to Package/Compare. That way you can ignore users and roles. However you may have to use uncheck the option "include dependencies" and check "ignore permissions".

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
    · Share on Twitter
This discussion has been closed.