SCH_GROUP_PRIVILEGES table

The SCH_GROUP_PRIVILEGES table describes privileges where the grantee is a privilege group and the target is an entire schema.

The clustering key consists of TABLE_UID, GRANTOR, GRANTOR_TYPE, GRANTEE, GRANTEE_TYPE, and PRIVILEGE_TYPE. The layout of the SCH_GROUP_PRIVILEGES table is identical to that of the SCH_PRIVILEGES, TBL_GROUP_PRIVILEGES, and TBL_PRIVILEGES tables.

Column number

Column Name

Data Type

Description

1*

GRANTOR

INT

Authorization ID of grantor or of owner if grantor is super ID acting for owner.

2*

GRANTOR_TYPE

CHAR(2)

The value is:

  • U - if user grant

  • O - if granted as schema owner

The system never performs privilege group grants.

3*

GRANTEE

INT

Privilege Group UID of the grantee. Links to PRIVILEGE_GROUPS in the SYSTEM_SECURITY_SCHEMA.

4 *

GRANTEE_TYPE

CHAR(2)

The value is U, which indicates that a privilege group can be neither owner nor PUBLIC.

5*

TABLE_UID

LARGEINT

The UID of the schema label object in the target schema.

6*

PRIVILEGE_TYPE

CHAR(2)

The privilege types are:

A - ALTER

C - CREATE

D - DELETE

D - R DROP

E - EXECUTE

I - INSERT

R - REFERENCES

S - SELECT

SU - USAGE

U - UPDATE

7

IS_GRANTABLE

CHAR(2)

The value is N, which indicates that the WITH GRANT OPTION does not apply to privilege group grants.

* Indicates primary key