Home » RDBMS Server » Security » Changing the privileges on executable files (Oracle 10g 10.2.0.3.0 on linux 64 bit)
Changing the privileges on executable files [message #317471] Thu, 01 May 2008 09:07 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,

can i change sqlplus and rman executible files rights in Oracle_home/bin for security reasons, like following

chmod 750 sqlplus
chmod 750 rman

what will be the side effects of this
Re: Changing the privileges on executable files [message #317474 is a reply to message #317471] Thu, 01 May 2008 09:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but then no one but the members of the group can execute these programs... but I think this what you want.

Regards
Michel
Re: Changing the privileges on executable files [message #317478 is a reply to message #317474] Thu, 01 May 2008 09:17 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
I just wanted to have confirmation that if i have rman backup and want to restore it to any other new server, the backup will not be disturb due to this action.

Then i can do chmod 750 to import export and datapump export and datapump import files too
Re: Changing the privileges on executable files [message #317486 is a reply to message #317478] Thu, 01 May 2008 09:38 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the backup will not be disturb due to this action.

Sure it will not if you have consistent user and group numbers across your network. If not, maybe you have to change the privileges on backup files before restoring. It also depends where you back up (disk, tape).

Quote:
Then i can do chmod 750 to import export and datapump export and datapump import files too

Yes.

Regards
Michel
Previous Topic: Login as sysdba in local host
Next Topic: Upgrade from 9.2 to 11.1 Label Security Problem
Goto Forum:
  


Current Time: Thu Mar 28 05:08:58 CDT 2024