The COLUMN_PRIVILEGES
view displays the privilege descriptors for all column-level privileges.
The table below lists the columns that are associated with the COLUMN_PRIVILEGES
view:
|
|
|
|
|
|
|
Specifies the name of
the catalog.
|
|
|
|
Specifies the name of
the schema.
|
|
|
|
Specifies the name of
the object.
|
|
|
|
Specifies the column
name.
|
|
|
|
Specifies the user name
of the grantor.
|
|
|
|
Specifies the grantor
type as U (User) or R (Role).
|
|
|
|
Specifies the name of
the user who is granted privileges.
|
|
|
|
Specifies the grantee
type as G (Group) or U (User).
|
|
|
|
Specifies the privilege
name as one of the following values:
|
|
|
|
Specifies the privilege type as GRANT or DENY.
|
|
|
|
Specifies if the privilege is grantable. The only valid value
is N (No).
|