- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle user & database permissions
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
Forums
Discussions
Discussions
Discussions
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
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
07-30-2004 01:41 AM
07-30-2004 01:41 AM
Thanks,
Tim
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2004 02:10 AM
07-30-2004 02:10 AM
SolutionAll datafiles and directories concerning the database and additional administration scripts were set with 770 or 660 permissions, as appropriate. All of these were owned by user oracle in group dba. WHo's a member of the dba group could vary depending on your environment, but ours only had oracle in it. The rc scripts were configured with the same ownership and permissions as any other.
Jeff Traigle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2004 02:11 AM
07-30-2004 02:11 AM
Re: Oracle user & database permissions
Depend on what you want, but putting an umask of 027 to oracle user may be good. As long as the Oracle software is installed with this user and Database Files are created with him, it will give access to him and his group (dba). This will be enough (no need for other users to read those files).
It may also be a good think to follow OFA organization wich is highly recommended by Oracle.
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2004 02:51 AM
07-30-2004 02:51 AM
Re: Oracle user & database permissions
oracle should be a normal user group dba is optional but thats a convention.
Oracle developers should be part of the dba group. Oracle users that need command line access should be part of the group.
All of these users should have a umask of 022 or 027.
Your ORACLE_HOME and ORACLE_SID environment variables should be set the same though the utility you use to set them will probably require some changes.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2004 03:29 AM
07-30-2004 03:29 AM
Re: Oracle user & database permissions
Tim