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.