What do the bitmask values for the PRIVILEGE column mean in the ALL_PRIVILEGE table of TIBCO Data Virtualization?
Article ID: KB0071529
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
ALL_PRIVILEGE table is a system table that could be found under Studio >> Composite Data Services >> Databases >> system. This table provides a list of resource privileges.
The PRIVILEGE column of this table returns an integer which is a bitmask value.
The PRIVILEGE column of this table returns an integer which is a bitmask value.
Issue/Introduction
This article states the values corresponding to the privilege bitmask values for the ALL_PRIVILEGE system table.
Environment
All supported environments.
Resolution
Below is the Privileges definition for the corresponding Privilege bitmask value.
---------------------------
GRANT = 128
NONE = 0;
READ = 1;
WRITE = 2;
EXECUTE = 4;
SELECT = 8;
UPDATE = 16;
INSERT = 32;
DELETE = 64;
READWRITE = READ | WRITE;
---------------------------
---------------------------
GRANT = 128
NONE = 0;
READ = 1;
WRITE = 2;
EXECUTE = 4;
SELECT = 8;
UPDATE = 16;
INSERT = 32;
DELETE = 64;
READWRITE = READ | WRITE;
---------------------------
Feedback
Yes
No
Powered by
