Adding Database Sets

After you have added databases, you can organize them into logical groups—database sets—to simplify management activity and reporting for databases with attributes in common.

To add a database set:

  1. In the Admin Portal, click Resources, then click Databases to display the list of databases.

  2. In the Sets section, click Add to create a new set.

  3. Type a name for the new set, an optional description, and select whether group membership is manual or dynamic.

    For manual sets, you can specify permissions for both the set itself and the members of the set. For dynamic sets, you can only specify permissions on the set.

  4. Identify the members of the set in one of two ways.

    • If set membership is Dynamic, type the SQL statement to execute to identify set members in the Query field. For example, if you want to add a set for the databases with a name that starts with ora, you could type a SQL statement like this:

      Copy 
      select id from VaultDatabase where name like 'ora%'

    • If you select Manual, click Members, then click Add to search for and select the databases to add as members.

  5. Click Save.