Friday, July 11, 2008

TABLE_PRIVILEGE_MAP

TABLE_PRIVILEGE_MAP

TABLE_PRIVILEGE_MAP describes privilege (auditing option) type codes. This table can be used to map privilege (auditing option) type numbers to type names.
Column
Datatype
NULL
Description
PRIVILEGE
NUMBER
NOT NULL
Numeric privilege (auditing option) type code
NAME
VARCHAR2(40)
NOT NULL
Name of the type of privilege (auditing option)
Oracle 11.1.0.6.0
select * from table_PRIVILEGE_MAP order by privilege;
PRIVILEGE
NAME
0
ALTER
1
AUDIT
2
COMMENT
3
DELETE
4
GRANT
5
INDEX
6
INSERT
7
LOCK
8
RENAME
9
SELECT
10
UPDATE
11
REFERENCES
12
EXECUTE
16
CREATE
17
READ
18
WRITE
20
ENQUEUE
21
DEQUEUE
22
UNDER
23
ON COMMIT REFRESH
24
QUERY REWRITE
26
DEBUG
27
FLASHBACK
28
MERGE VIEW
29
USE
30
FLASHBACK ARCHIVE