10.6.1.2 pyqGetHostACE Function

The pyqGetHostACE function gets the existing host access control entry (ACE) for the specified user. An exception is raised if the host ACE doesn't exist for the specified user.

Syntax

FUNCTION sys.pyqGetHostACE(
  p_username IN VARCHAR2
)

Parameter

p_username - Database user to look for the host ACE.

Example

If user OMLUSER has access to the cloud host, i.e., ibuwlq4mjqkeils-omlrgpy1.adb.us-region-1.oraclecloudapps.com, the ADMIN user can run the following to check the user's privileges:

SQL> set serveroutput on
DECLARE 
    hostname VARCHAR2(4000);
BEGIN
    hostname := pyqGetHostACE('OMLUSER'); 
    DBMS_OUTPUT.put_line ('hostname: ' || hostname);
END;
/
SQL> hostname: ibuwlq4mjqkeils-omlrgpy1.adb.us-region-1.oraclecloudapps.com 
PL/SQL procedure successfully completed.