Reference Guide > TDV and Business Directory System Tables > ALL_PRIVILEGES
 
ALL_PRIVILEGES
This table provides a list of resource privileges.
Column
TDV
JDBC Data Type
Nullable
Description
RESOURCE_ID
INTEGER
 
Identifier of the resource.
RESOURCE_NAME
VARCHAR
 
Name of the resource.
COLUMN_ID
INTEGER
 
Identifier of the column, -1 if not a column.
COLUMN_NAME
VARCHAR
 
Name of the column, NULL if not a column.
OWNER_ID
INTEGER
 
Identifier of the user who created/owns the resouce. Same as USER_ID in the ALL_USERS table.
OWNER
VARCHAR
 
User name of the user who created/owns the resouce. Same as USERNAME in the ALL_USERS table.
MEMBER_ID
INTEGER
 
Identifier of the user who has privilege on the resource. Same as USER_ID in the ALL_USERS table.
MEMBER
VARCHAR
 
User name of the user who has privileges on the resouce. Same as USERNAME in the ALL_USERS table.
MEMBER_TYPE
VARCHAR
 
The member type; can be either GROUP or USER.
PRIVILEGE
INTEGER
 
Privilege bitmask value.