Solved

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

Posted on 2008-06-26
2
819 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
2 Comments
 
LVL 34

Accepted Solution

by:
Mark Geerlings earned 25 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 25 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Many of us in IT utilize a combination of roaming profiles and folder redirection to ensure user information carries over from one workstation to another; in my environment, it was to enable virtualization without needing a separate desktop for each…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
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.

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now