ACL情報を確認する

Tweet

Pocket

/*
|| ACL情報の確認
*/
set echo off
set lines 150
set pages 1000

clear col
ttitle off

ttitle left ‘■■■■　ACL情報　■■■■’
spool acl_info.lis

col host form a20 head “HOST”
col lower_port form 999,999 head “LOWER_PORT”
col upper_port form 999,999 head “UPPER_PORT”
col acl form a50 head “ACT”
col aclid form a30 head “ACTID”
col acl_owner form a10 head “ACT_OWNER”

select
host –“HOST”
,lower_port –“LOWER_PORT”
,upper_port –“UPPER_PORT”
,acl –“ACT”
,aclid –“ACTID”
,acl_owner –“ACT_OWNER”
from dba_network_acls
;

spool off
clear col
ttitle off

|| ACL情報の確認
*/
set echo off
set lines 150
set pages 1000

clear col
ttitle off

ttitle left ‘■■■■　ACL情報　■■■■’
spool e:\work\20190527\acl_info.lis

col host form a20 head “HOST”
col lower_port form 999,999 head “LOWER_PORT”
col upper_port form 999,999 head “UPPER_PORT”
col acl form a50 head “ACT”
col aclid form a30 head “ACTID”
col acl_owner form a10 head “ACT_OWNER”

select
host –“HOST”
,lower_port –“LOWER_PORT”
,upper_port –“UPPER_PORT”
,acl –“ACT”
,aclid –“ACTID”
,acl_owner –“ACT_OWNER”
from dba_network_acls
;

spool off
clear col
ttitle off