DATABASE_PRIVILEGE_GROUPS table

DATABASE_PRIVILEGE_GROUPS table represents which privilege groups are associated with which databases. The primary key is the combination of the DB_UID, and PRIV_GROUP_ID columns.

A user database has four implicit privilege groups that are created along with the database:

  • A default privilege group is for all users associated with the database

  • A privilege group for users with read access to the database

  • A privilege group for users with write access to the database

  • A privilege group for users with create access to the database

Additional explicit privilege groups may be created for the database.

Column number

Column Name

Data Type

Description

1*

DB_UID

LARGEINT

The catalog UID of the database.

2*

PRIV_GROUP_UID

INT

Links to ALL_DATABASES.

3

PRIV_GROUP_TYPE

CHAR(2)

  • MD

  • TR

  • TW

  • TC

  • E

For more information, see PRIVILEGE_GROUPS TABLE.

* Indicates primary key