13.7.1.1 pyqAppendHostACE Procedure

The pyqAppendHostACE procedure appends an access control entry (ACE) to the access control list (ACL) of the cloud host. The ACL controls access to the cloud host from the database, and the ACE specifies the connect privilege granted to the specified user name.

Syntax

PROCEDURE SYS.pyqAppendHostACE(   
    username IN VARCHAR2,   
    host_root_domain IN VARCHAR2
)

Parameter

username - Database user to whom the connect privilege to the cloud host is granted.

host_root_domain - Root domain of the cloud host. For example, if the URL is https://qtraya2braestch-omldb.adb.us-sanjose-1.oraclecloudapps.com, the root domain of the cloud host is: adb.us-sanjose-1.oraclecloudapps.com.

Example

exec pyqAppendHostAce('OMLUSER','adb.us-region-1.oraclecloudapps.com');

Note:

OML username is case sensitive

Parent topic: Access and Authorization Procedures and Functions