 |
|
Oracle Tips by Burleson |
Chapter 7 Oracle Network Security
allowed in the invited list. If this list is
specified, then it takes precedence over the excluded list.
After making the change in protocol.ora (in
Oracle 8i) or sqlnet.ora (in Oracle 9i and above), stop and restart
the listener. The values take effect only during the startup of the
listener. After this change, if a user, regardless of the
authentication in the database or authority level, connects from the
node enrollment1, he or she receives the error
$ sqlplus
nathan/5ucc355@claimdb
SQL*Plus: Release 9.2.0.2.0 - Production on Wed
Jul 2 11:57:06 2003
Copyright (c) 1982, 2002, Oracle Corporation.
All rights reserved.
ERROR:
ORA-12537: TNS:connection closed
Enter user-name:
The error message is a little less intuitive It
does not explicitly state the nature of the error.
The same user connecting from node CLAIMS1 will
succeed. In this case, the listener simply rejects the connection
originating from the node ENROLLMENT1, regardless of the user.
The above text is
an excerpt from
the bestselling book:
Oracle
Privacy Security Auditing.
It's only $39.95 and has an
download of working security scripts:
This is the only authoritative
book on Oracle Security, Oracle Privacy, and Oracle Auditing written
by two of the world’s leading Oracle Security experts.
This indispensable book is only $39.95 and has an
download of working security scripts:
http://rampant-books.com/book_2003_2_audit.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
