GENERAL_PERMISSIONS_GRID
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ON_WHAT_ID | NUMBER(38) | N | NO | NO | NO | |
| ON_WHICH_TABLE | VARCHAR2(30.0) | N | NO | NO | NO | |
| SCOPE | VARCHAR2(20.0) | Y | NO | NO | NO | |
| USER_ID | NUMBER(38) | Y | NO | NO | NO | |
| GROUP_ID | NUMBER(38) | Y | NO | NO | NO | |
| ROLE | VARCHAR2(200.0) | Y | NO | NO | NO | |
| READ_PERMISSION_P | VARCHAR2(1.0) | Y | NO | NO | NO | |
| COMMENT_PERMISSION_P | VARCHAR2(1.0) | Y | NO | NO | NO | |
| WRITE_PERMISSION_P | VARCHAR2(1.0) | Y | NO | NO | NO | |
| ADMINISTER_PERMISSION_P | VARCHAR2(1.0) | Y | NO | NO | NO | |
Query:
select
p.on_what_id, p.on_which_table,
p.scope, p.user_id, p.group_id, p.role,
decode(sum(decode(p.permission_type, 'read', 1, 0)), 0, 'f', 't')
as read_permission_p,
decode(sum(decode(p.permission_type, 'comment', 1, 0)), 0, 'f', 't')
as comment_permission_p,
decode(sum(decode(p.permission_type, 'write', 1, 0)), 0, 'f', 't')
as write_permission_p,
decode(sum(decode(p.permission_type, 'administer', 1, 0)), 0, 'f', 't')
as administer_permission_p
from general_permissions p
group by
p.on_what_id, p.on_which_table,
p.scope, p.user_id, p.group_id, p.role
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002