[Home] [Help] [Dependency Information]
Object Name: | DBA_ILMOBJECTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Policies and the objects they affect in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POLICY_NAME | VARCHAR2 | (128) | Yes | Name of the policy |
OBJECT_OWNER | VARCHAR2 | (128) | Yes | Owner of the object |
OBJECT_NAME | VARCHAR2 | (128) | Yes | Name of the object |
SUBOBJECT_NAME | VARCHAR2 | (128) | Name of the subobject | |
OBJECT_TYPE | VARCHAR2 | (18) | Type of the object | |
INHERITED_FROM | VARCHAR2 | (20) | Is the policy inherited? If so from where? | |
TBS_INHERITED_FROM | VARCHAR2 | (30) | If this tablespace policy is inherited, from which tablespace? | |
ENABLED | VARCHAR2 | (3) | Is the policy enabled on the object? | |
DELETED | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT POLICY_NAME
, OBJECT_OWNER
, OBJECT_NAME
, SUBOBJECT_NAME
, OBJECT_TYPE
, INHERITED_FROM
, TBS_INHERITED_FROM
, ENABLED
, DELETED
FROM SYS.DBA_ILMOBJECTS;
|
|
|