Solved

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

Posted on 2008-06-26
2
838 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 35

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

SHARE your personal details only on a NEED to basis. Take CHARGE and SECURE your IDENTITY. How do I then PROTECT myself and stay in charge of my own Personal details (and) - MY own WAY...
OfficeMate Freezes on login or does not load after login credentials are input.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

777 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