Chapter 13 Managing Database Access

Generating privileges

You can create or modify privileges directly using an ODBC driver or indirectly using a script.

To generate privileges:

1. Select Database→Generate Database to open the Database Generation window, and specify the standard options, including whether you want to generate a script or generate directly to an ODBC connection.
   
   For detailed information about using this window, see the "Generating a Database" section in the "Generating a Database from a PDM" chapter.
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 the "Quick launch selection and settings sets" section in the "Generating a Database from a PDM" chapter.
3. [optional] Click the Selection tab and select the Users sub-tab at the bottom of the page. Select the users that you want to generate for.
4. Click OK to begin the generation.

Copyright (C) 2005. Sybase Inc. All rights reserved.