Visit Our UNIX and Linux User Community


Permission to Oracle server to create a directory in a particular path


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Permission to Oracle server to create a directory in a particular path
# 15  
Old 08-12-2013
Quote:
Originally Posted by rbatte1
Okay, well you will need to consult them to achieve this, assuming that you have the Oracle privilege to so this. Smilie



Robin
Thanks for the reply.Can you tell what should i do
# 16  
Old 08-12-2013
The account running the database (sounds like oracle for you) needs unix permissions to write to the unix directory in question. Within the database your account (seems like usr_1) would need to have the oracle system privilege CREATE ANY DIRECTORY

Of course, you have to consider that you are then taking datab out of the database and writing it in a plain file. Does this breach your security rules? Who else will be able to see the data? is there anything client on company confidential in it (e.g. bank accounts, contact details, medical stuff, corporate statements or financial investments etc.)

This latter point is not for me to draw a conclusion about because I don't know what business you are in, but we all have to consider the risks of exposing data, even to people we trust.





Robin
Liverpool/Blackburn
UK
This User Gave Thanks to rbatte1 For This Post:
# 17  
Old 08-12-2013
Quote:
Originally Posted by rbatte1
The account running the database (sounds like oracle for you) needs unix permissions to write to the unix directory in question. Within the database your account (seems like usr_1) would need to have the oracle system privilege CREATE ANY DIRECTORY

Of course, you have to consider that you are then taking datab out of the database and writing it in a plain file. Does this breach your security rules? Who else will be able to see the data? is there anything client on company confidential in it (e.g. bank accounts, contact details, medical stuff, corporate statements or financial investments etc.)

This latter point is not for me to draw a conclusion about because I don't know what business you are in, but we all have to consider the risks of exposing data, even to people we trust.





Robin
Liverpool/Blackburn
UK
Thanks.Smilie

Previous Thread | Next Thread
Test Your Knowledge in Computers #132
Difficulty: Easy
Many of the command line and graphical utilities in a Linux distro are very similar to a Unix system.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

What is the difference ../directory path and ./directory path in ksh?

What is the difference ../directory path and ./directory path in ksh? (1 Reply)
Discussion started by: TestKing
1 Replies

2. UNIX for Beginners Questions & Answers

Convert Relative path to Absolute path, without changing directory to the file location.

Hello, I am creating a file with all the source folders included in my git branch, when i grep for the used source, i found source included as relative path instead of absolute path, how can convert relative path to absolute path without changing directory to that folder and using readlink -f ? ... (4 Replies)
Discussion started by: Sekhar419
4 Replies

3. Solaris

Permission for files in the path

Hi All, I have this file system /sys/app/ and application creating many file under that path. I want any created file under that path to be created with 644 permission Any help support in this please! (2 Replies)
Discussion started by: AbuAliiiiiiiiii
2 Replies

4. AIX

How to set owner and permission for files/directory in directory in this case?

Hi. My example: I have a filesystem /log. Everyday, log files are copied to /log. I'd like to set owner and permission for files and directories in /log like that chown -R log_adm /log/* chmod -R 544 /log/*It's OK, but just at that time. When a new log file or new directory is created in /log,... (8 Replies)
Discussion started by: bobochacha29
8 Replies

5. Shell Programming and Scripting

Permission to Oracle server

i need to give permission to ORACLE SERVER to create a directory in a particular path. How to do it?Oracle server is installed in Unix (11 Replies)
Discussion started by: rafa_fed2
11 Replies

6. Red Hat

Mkdir: cannot create directory `/home/phpmy/html': Permission denied centos

for incompatibility installation problems, I've decided to reinstall Centos 6.3 as can be seem from the df output, I've partitioned both / and and /home directories $ df -h Filesystem Size Used Avail Use% Mounted on /dev/sda8 12G 5.3G 6.5G 45% / tmpfs ... (2 Replies)
Discussion started by: jediwannabe
2 Replies

7. UNIX and Linux Applications

DSCC can not create Directory Server

Hi all, I have a problem when I try to create a Directory Server on Directory Service Control Center - DSCC. The log shows the following: Creating Directory Server test1:389. Server Logs: couldn't set locale correctly couldn't set locale correctly Directory '/var/ds/' already exists... (1 Reply)
Discussion started by: Yohanna Flores
1 Replies

8. UNIX for Dummies Questions & Answers

mkdir: cannot create directory `/builds/somedir/': Permission denied

Hi, I am trying to run a shell script which contains an mkdir command as part of the execution. The script fails with the following error: mkdir: cannot create directory `/builds/somedir/': Permission denied The user running the script is 'harry' and belongs to group 'school'.... (5 Replies)
Discussion started by: Technext
5 Replies

9. Shell Programming and Scripting

Retrieve directory path from full file path through sh

Hi, I have a file abcd.txt which has contents in the form of full path file names i.e. $home> vi abcd.txt /a/b/c/r1.txt /q/w/e/r2.txt /z/x/c/r3.txt Now I want to retrieve only the directory path name for each row i.e /a/b/c/ /q/w/e/ How to get the same through shell script?... (7 Replies)
Discussion started by: royzlife
7 Replies

10. Solaris

root can not change the permission of old oracle archive directory in solaris 8

I am using oracle 9i with sun solaris 8 on Sun E 250 server.earlier we are taking backup of oracle archive files on /orabackup directory.in which archive file are stored with ...arc.Z extension. now we have changed the archive backup directory.now when we are trying to delete earlier directory... (3 Replies)
Discussion started by: mahanalok
3 Replies

Featured Tech Videos