Generating Privileges

You can generate privileges to a script or to a live database connection.

  1. Select Database > Generate Database to open the Database Generation window, and specify the standard options, including whether you want to generate to a script or to a live database connection.

    For detailed information about using this window, see Generating a Database.

  2. Select "Users & Groups (with privileges)" from the Settings set list in the Quick Launch groupbox at the bottom of the window. This settings set specifies standard options for generating privileges.

    or:

    Click the Options tab and click on User in the left-hand pane to display the user generation options. Change the default options as appropriate.

    For detailed information about settings sets, see Quick Launch Selection and Settings Sets.

  3. [optional] Click the Selection tab and select the Users sub-tab at the bottom of the tab. Select the users that you want to generate for.
  4. Click OK to begin the generation.