Unix privileges for Oracle user

Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Unix privileges for Oracle user
# 1  
Old 08-24-2011
Unix privileges for Oracle user


I have an issue I am currently trying to execute Unix Commands through a Java Source within Oracle 10g I am currently running Oracle on a Unix Sun Solaris Platform.

I am executing the Java Source through a PL/SQL and on SQL Navigator it is saying that it has been executed.

I'm trying to execute
ls -al > /File1/list/list.txt

But when i go to the directory /list it is not being created within that file list.txt does not exist.

What privileges are needed on the unix side so that i can execute this command through the Java Source.

Last edited by pludi; 08-24-2011 at 06:50 AM..
# 2  
Old 09-01-2011
The directory you mentioned should be writable by the user which is running your Oracle 10 G processes.
# 3  
Old 09-01-2011
I believe you need some java-specific privileges,
see Tim Hall's site for more details.

Grant Privileges

The relevant permissions must be granted from SYS for JServer to access the file system:
EXEC DBMS_JAVA.grant_permission('SCHEMA-NAME', 'java.io.FilePermission', '<<ALL FILES>>', 'read ,write, execute, delete');
EXEC DBMS_JAVA.grant_permission('SCHEMA-NAME', 'SYS:java.lang.RuntimePermission', 'writeFileDescriptor', '');
EXEC DBMS_JAVA.grant_permission('SCHEMA-NAME', 'SYS:java.lang.RuntimePermission', 'readFileDescriptor', '');
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. HP-UX

User with root privileges in hp ux

hi, i am new in hp ux and i must create a user with root privileges and so i disable ssh connection from root login. thanks.. (6 Replies)
Discussion started by: eliste
6 Replies

2. Ubuntu

Create New User with the same group nd privileges of the other user

Hi, Anyone can help me on how to duplicate privileges and group for useroradb01 to userrootdb01. I have currently using "useroradb01" and create a newly user "userrootdb01". I want both in the sames privileges and group. Please see the existing users list below; drwxr-xr-x 53 useroradb01... (0 Replies)
Discussion started by: fspalero
0 Replies

3. Shell Programming and Scripting

Special group & user privileges

Special group and user privileges help I'm having some trouble understanding the group and user privileges. So let's say I make a group.. and assign some users to the groups that I made. How would I -- 1) Allow different groups and different users to have full privileges over a file with .X... (5 Replies)
Discussion started by: LibRid
5 Replies

4. Programming

Grant privileges in Oracle

i have installed oracle 10g and two databases. i enter database1 as sysdba and create a user called user1.i give the privileges as "select on" to user1. i enter sqlplus from the shell prompt. i enter as user1. but when i do "select * from emp" i have a "the table doesn't exist". how can i give... (3 Replies)
Discussion started by: symeje
3 Replies

5. Shell Programming and Scripting

How can i copy user permissions(privileges) to a group

Hey there I have a problem and i was hoping that you guys could help me out I want to copy a user privileges to a group and i need to copy all privileges(Recursively) every directory with all its sub directories and I tried some solution and it did not work. I used the following command:- ... (14 Replies)
Discussion started by: The Dark Knight
14 Replies

6. Linux

grant root privileges to ordinary user

Hi, Is it possible to grant root privileges to an ordinary user? Other than 'sudo', is there some way under Users/Groups configuration? I want ordinary user to be able to mount, umount and use command mt. /Brendan (4 Replies)
Discussion started by: brendan76
4 Replies

7. Solaris

user with limited privileges

Hi, I tried to search, but could not find answer for this really: Is it possible to create a user that would have access only to a defined list of files? I would like to create a user that can access a set of files that are located behind different path. This user should not have access to... (1 Reply)
Discussion started by: Juha
1 Replies

8. AIX

Privileges User ((Please urgent))

Hi ,,, I create new user on AIX 5.2 but the user have privileges root user Why the user have privileges root user although the user specification not the same specification root user ??? PLease help me ... (6 Replies)
Discussion started by: AIX122
6 Replies

9. UNIX for Advanced & Expert Users

new user - basic privileges

I want to create a new user with very basic priviliges. How to jail the user in his home directory?? how to deny him some of unix commands (rm for example) thx (1 Reply)
Discussion started by: melanie_pfefer
1 Replies

10. UNIX for Advanced & Expert Users

User Privileges

I have used several Linux Flavors and now I need to know something. I have the ROOT user and then I have my personal user. What I need to do is for my normal user to be able to write files to directories where appearntly, only the root user has privileges. For example, to write files to... (1 Reply)
Discussion started by: gdboling
1 Replies
Login or Register to Ask a Question