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
- Click New.
- Enter a name for the new table set, and then click Next.
- Enter a Table Name.
Note: To include all the tables, rather than selecting each one, select the ALL_TS.
- Click Add for each table name you enter.
- To remove a table from the set, click the delete icon for that table.
- Click Select Another Table Set.