- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- controlfile permissions not umask settings
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-21-2004 11:36 PM
тАО11-21-2004 11:36 PM
controlfile permissions not umask settings
Does anyone know why on creation of a controlfile backup (alter database backup controlfile to '......';) the permissions are rw-rw---?? Can I change these settings?? My umask settings for the Oracle user are set to 0 which on creating a blank file with the touch command creates a file with rw-rw-rw permissions. Why should this be different? I really need 666 for the controlfile backup as it's the only way a backup configuration I have will work.
Regards and thanks in advance,
Pablo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2004 12:06 AM
тАО11-22-2004 12:06 AM
Re: controlfile permissions not umask settings
see the following link and answer of Clay Stephenson.If you have umask set to 000 then whatever mode results when the application creats a file is the mode that the programmer intended.
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=723084
regds,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2004 12:14 AM
тАО11-22-2004 12:14 AM
Re: controlfile permissions not umask settings
Which utility do you use to run this command ?
You probably have a front end and connect to the Database through SQLNET. Therefore, the permissions would be the one of the user starting the tns process (listener).
What are they ?
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2004 01:26 AM
тАО11-22-2004 01:26 AM
Re: controlfile permissions not umask settings
SQL> alter database backup controlfile to '/tmp/bk1';
SQL> host chmod 666 /tmp/bk1
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2004 01:54 AM
тАО11-22-2004 01:54 AM
Re: controlfile permissions not umask settings
I have tested the creation of the control file directly from the db server with sqlplus thus avoiding any connection via Net8, therefore Oracle directly creates the file with these permissions. But I am still unable to identify the origin of the permissions granted. When creating a datafile, the same permissions are granted.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2004 02:09 AM
тАО11-22-2004 02:09 AM
Re: controlfile permissions not umask settings
If you set the oracle account umask to 022 - then files created by oracle will have 640 as their permission - if you change it to 000 - then the files are created as 660.
The permissions on $ORACLE_HOME/bin/oracle are set to rwsr_s__x
I tried setting the permission on $ORACLE_HOME/bin/oracle to rwsrwsrwx and the files are still created the same.
For security it's best to have the Oracle files created as 640 so that only the Oracle account owner can delete database files. Oracle will allow you to change for the Oracle group - but does not allow you to give delete (write) permission to world. Changing after file creation is probably your safest option.
Patti