?
Solved

Restict access to SQLNET.ORA, LISTENER.LOG, SQLNET.LOG to only Administrators.

Posted on 2008-06-26
2
Medium Priority
?
867 Views
Last Modified: 2013-12-04
Hi,

        I need to secure the following files,  SQLNET.ORA, LISTENER.LOG, SQLNET.LOG on our Oracle db. Only Admins, DBA's and SYSTEM accounts should be able to access. I checked our system and users are listed as having read write and execute. If I revoke all permissions for local users to these files, will this "break" their functionality in Oracle? Do regular users need these files to write to?

THanks, MIssyMadi
0
Comment
Question by:missymadi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 100 total points
ID: 21875613
If you are talking about these files in the Oracle_home on the database server itself, no, regular users don't need any access to these files at all.  They usually don't need any access to other files or directories in the Oracle_home on the server either!

If they have local Oracle clients on their own PC, they will need access to sqlnet.ora and tnsnames.ora on their client, but not on the server.
0
 
LVL 33

Assisted Solution

by:Dave Howe
Dave Howe earned 100 total points
ID: 21876289
you will need only that the account used to run the sql listener (usually local system) and admins have access - there is no need for users to have read access (although no real harm there either). Users and the listener need no write access to the .ora file, which should be read only even for the listener.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a recent article here at Experts Exchange (http://www.experts-exchange.com/articles/18880/PaperPort-14-in-Windows-10-A-First-Look.html), I discussed my nine-month sandbox testing of the Windows 10 Technical Preview, specifically with respect to r…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question