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, click the Permissions tab, and select a user, group or role:

  2. Click the Ellipsis button beside the Columns box to open the Column Permissions dialog box. The columns in the list show the permissions available for each of the table's columns.

  3. Click inside a column cell until the desired state is displayed, or select one of the Permission state tools at the bottom of the tab.
  4. Click OK to close the Column Permissions dialog box and return to the property sheet. The cells corresponding to selected column permissions contain ellipsis symbols. Click on one of these symbols to display the associated column permissions information in the Columns box.

  5. Click OK.
Parent topic: Granting Object Permissions