Defining Column Permissions

You can fine tune the permissions on a table by specifying permissions on a column-by-column basis. The available column permissions are specified in the DBMS resource file. Note that any new or modified permission may not be supported during generation or reverse-engineering.

  1. Open the property sheet of a table, user, role, or group, and click the Permissions tab. For a table, select a user, group or role in the list to whom you want to grant column permissions. For a user, group or role, select a table in the list for which you want to specify permissions.
  2. Click the ellipsis button to the right of the Columns field to open the Column Permissions dialog. The columns in the list show the permissions available for each of the table's columns.


  3. To change the state of a permission (whether granted directly, or inherited from a group), click in the appropriate column to cycle through the available states, or click on the appropriate tools in the Permission state group box at the bottom of the tab.
  4. Click OK to close the dialog and return to the property sheet. The cells for which specific permissions have been set for columns now contain ellipsis symbols. Click on one of these symbols to display the associated column permissions information in the Columns field:


  5. Click OK to close the property sheet and return to the model.