431c15b1fb
Add WebServer files. git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4189 248e525c-4dfb-0310-94bc-949c084e9493
9 lines
340 B
Plaintext
9 lines
340 B
Plaintext
REM Show the dangling references to dropped users in the ACL that is assigned
|
|
REM to '*'.
|
|
|
|
SELECT ACL, PRINCIPAL
|
|
FROM DBA_NETWORK_ACLS NACL, XDS_ACE ACE
|
|
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL AND
|
|
NACL.ACLID = ACE.ACLID AND
|
|
NOT EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME = PRINCIPAL);
|