Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_HOST_ACES

Object Details
Object Name: CDB_HOST_ACES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Access control entries defined in host access control lists in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
HOST VARCHAR2 (1000) Yes Network host
LOWER_PORT NUMBER (5)
Lower bound of the port range
UPPER_PORT NUMBER (5)
Upper bound of the port range
ACE_ORDER NUMBER
Yes Order number of the access control entry
START_DATE TIMESTAMP(6) (11)
Start-date of the access control entry
END_DATE TIMESTAMP(6) (11)
End-date of the access control entry
GRANT_TYPE VARCHAR2 (5)
Whether the access control entry grants or denies the privilege
INVERTED_PRINCIPAL VARCHAR2 (3)
Whether the principal is inverted or not
PRINCIPAL VARCHAR2 (128)
Principal the privilege is applied to
PRINCIPAL_TYPE VARCHAR2 (11)
Type of the principal
PRIVILEGE VARCHAR2 (128)
Privilege
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HOST
,      LOWER_PORT
,      UPPER_PORT
,      ACE_ORDER
,      START_DATE
,      END_DATE
,      GRANT_TYPE
,      INVERTED_PRINCIPAL
,      PRINCIPAL
,      PRINCIPAL_TYPE
,      PRIVILEGE
,      CON_ID
FROM SYS.CDB_HOST_ACES;

Dependencies

[top of page]

SYS.CDB_HOST_ACES does not reference any database object

SYS.CDB_HOST_ACES is referenced by following:

SchemaPUBLIC
SynonymCDB_HOST_ACES