You can generate privileges to a script or to a live database connection.
-
Select 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.
-
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.
-
[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.
-
Click OK to begin the generation.