Syntax

FUNCTION sys.rqGetHostACE(
  p_username IN VARCHAR2
)

Parameter

p_username - Database user to look for the host ACE.

Example

If user OMLUSER has access to 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 := rqGetHostACE('OMLUSER'); 
    DBMS_OUTPUT.put_line ('hostname: ' || hostname);
END;
/
SQL> hostname: QTRAYA2BRAESTCH-OMLTEMP.adb.us-sanjose-1.oraclecloudapps.com 
PL/SQL procedure successfully completed.