 |
|
Oracle Tips by Burleson |
Chapter 4 General Oracle Security
Enter
user-name: scott/tiger|
ERROR:
ORA-12546: TNS:permission denied
Note the error: “ORA-12546 : TNS:permission
denied,” meaning the execute on the Oracle executable failed.
However, the connection is attempted now using a connect string,
i.e. forcing it to go through the regular IPC or TCP/IP process.
Enter
user-name: scott/tiger@claimdb
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL>
The connection was successful.
Remove the execute permissions on Oracle
executables from others as a precaution to prevent malicious use.
Filesystem
Permissions
Oracle uses several filesystems to place a
variety of files. We will assume here that the Oracle software owner
is oracle and the primary group is oinstall, with other memberships
in the group dba.
The directory where the
Oracle software files are stored is called Oracle Home, identified
as an environmental variable in UNIX labeled ORACLE_HOME.
The above text is
an excerpt from
the bestselling book:
Oracle
Privacy Security Auditing.
It's only $39.95 and has an
immediate 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
immediate 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
|
|
