Configuration and Administration

Table Set

This page is accessed via Configuration and Administration > VPD Management > Table Set Manager.

Note: Only the DBA.ADMIN user can access and use the Table Set Manager.

The Table Set option enables administrators to edit, delete, and create table sets. A table set is a list of tables that have been grouped together for access or other administration purposes. For example, the table set ALL_TS lists all the tables.

A table can be listed in more than one table set. Predefined and user-defined table sets can be used in the Auto Grant Manager to provide fine-tuned, automatic data access across domains and subdomains.

You can create new table sets comprised of tables that you select.

Creating New Table Sets

  1. Click New.
  2. Enter a name for the new table set, and then click Next.
  3. Enter a Table Name.

    Note: To include all the tables, rather than selecting each one, select the ALL_TS.

  4. Click Add for each table name you enter.
  5. To remove a table from the set, click the delete icon for that table.
  6. Click Select Another Table Set.

Related Topics