8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: host_aces.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/12c/host_aces.sql -- Author : Tim Hall -- Description : Displays information about host ACEs. -- Requirements : Access to the DBA views. -- Call Syntax : @host_aces -- Last Modified: 10/09/2014 -- ----------------------------------------------------------------------------------- SET LINESIZE 200 COLUMN host FORMAT A20 COLUMN principal FORMAT A30 COLUMN privilege FORMAT A30 COLUMN start_date FORMAT A11 COLUMN end_date FORMAT A11 SELECT host, lower_port, upper_port, ace_order, TO_CHAR(start_date, 'DD-MON-YYYY') AS start_date, TO_CHAR(end_date, 'DD-MON-YYYY') AS end_date, grant_type, inverted_principal, principal, principal_type, privilege FROM dba_host_aces ORDER BY host, ace_order; SET LINESIZE 80