Permission to Oracle server


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Permission to Oracle server
# 1  
Old 07-22-2013
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
# 2  
Old 07-22-2013
What is the error you are getting?
Do you have the access to the unix server and the location where you want to create the folder.
# 3  
Old 07-22-2013
Quote:
Originally Posted by millan
What is the error you are getting?
Do you have the access to the unix server and the location where you want to create the folder.

Yes .I have created a procedure in oracle which we will create a folder in the path i have given .But i am getting an error that folder can't be created.
# 4  
Old 07-22-2013
If you want to give permission to oracle to create files under some directory make an entry into ALL_DIRECTORIES with the user you want to run the PL/SQL or data pump etc.
# 5  
Old 07-22-2013
Quote:
Originally Posted by vidyadhar85
If you want to give permission to oracle to create files under some directory make an entry into ALL_DIRECTORIES with the user you want to run the PL/SQL or data pump etc.
The entry is already there
# 6  
Old 07-22-2013
Could you please post the Oracle user and entry from ALL_DIRECTORIES also the owner and permission details of directory?

Also the exact error message
# 7  
Old 07-22-2013
Can u check if you have write permission to the folder inside which you are creating another folder.

Code:
 
ls -ld foldername

Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Strange permission issue on Linux server.

Starting sendmail throws this error: I decided to see the permission on the files under /etc/mail and this is the output: # ls -ltr total 284 -rwxr-xr-x. 1 root root 1847 Jan 27 2014 virtusertable -rwxr-xr-x. 1 root root 127 Jan 27 2014 trusted-users -rwxr-xr-x. 1 root root 92... (3 Replies)
Discussion started by: mohtashims
3 Replies

2. Shell Programming and Scripting

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

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

3. Web Development

You don't have permission to access / on this server.

Hello, I've set all permissions for all on my Server folders: chmod a+rwx ServerFolder When I browse to localhost:8000 I receive the following error: You don't have permission to access / on this server. why ? thanks (9 Replies)
Discussion started by: aneuryzma
9 Replies

4. 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

5. UNIX for Dummies Questions & Answers

security permission logging onto Oracle database

Hello, I'm trying to login to an Oracle databse without entering the user/passwd. The server resides on an AIX 5.1 system, and using LDAP. I'm entering the following command >sqlplus / @ORACLE_SID This should work but for some odd reason I get a login denied. But if I enter the user id... (1 Reply)
Discussion started by: ctcuser
1 Replies

6. UNIX for Advanced & Expert Users

mount: failed, reason given by server: Permission denied

Hi , I have a filesystem on AIX 4.3.3 which i need to share with other clients who use Windows NT and Redhat linux 7.3. I use samba to share this with Windows NT Clients. Now i was to share this with Linux clients. When i try to nfs mount this on Linux i get "mount: failed, reason given by... (1 Reply)
Discussion started by: Sushesh
1 Replies
Login or Register to Ask a Question