Updating an oracle sequence via plsql Chat live sex cam gratis sin registro n y
Runtime Permission', 11 '*', 12 'write File Descriptor' ); 13 end; 14 / PL/SQL procedure successfully completed. WORLD Tom- procedure dbms_java.grant_permission is available from 8.1.6.
Is there any workaround available in 8.1.5 to achieve the same functionality. It throws the following error if i try to assign permission to any user...
Runtime Permission', '*', 'read File Descriptor' ); -- try to accomodate input/output redirection ('SCOTT', '
who is terri irwin dating - Updating an oracle sequence via plsql
File Permission', '/usr/bin/*', 'execute'); dbms_java.grant_permission ('SCOTT', '
Runtime Permission', '*', 'write File Descriptor' ); -- try to accomodate input redirection dbms_java.grant_permission ('SCOTT', '
you would need to run a SHELL that understands "|" and "", something like: sh -c 'ps -ef | grep oracle' BUT -- then you would need execute on /bin/sh, with that you can run ANY command as the user "oracle" (or who ever starts the database).
That would let you for example "sh -c rm -rf /*" and erase everything oracle is allowed to erase.
This is like someone on windows trying to run "dir", "dir" is not a program -- its an internal command.
similarly, ps -ef | grep oracle is not a command -- its an internal command to your shell that says "start ps, redirect its stdout, start grep, redirect its stdin".
Creating a standard ftp shell script with predefined input parms is better. From what I can remember the DBMS_PIPE solution (see this site) doesn't have the special character limitation. Apologies for my total lack of java knowledge (I'm getting there...), but your example (which worked fine in 8i) appears to bomb out under my 9i version.
Could you post if the same code works under one of your 9i versions?
We could have allowed it to execute /usr/bin/* or * or whatever -- I'm just letting it execute that one program. To make this callable as a procedure (ignoring the return code), we'll create a procedure: [email protected] exec rc('/usr/bin/ps -ef'); UID PID PPID C STIME TTY TIME CMD root 0 0 0 Aug 17 ? EXE *** 2001-11-22 .720 *** SESSION ID:(17.10) 2001-11-22 .610 Specified COMMAND search directory bad Microsoft(R) Windows 98 (C)Copyright Microsoft Corp 1981-1998. You see the error message there "Specified COMMAND search directory bad" and a command prompt. Unfortunately for you - this command prompt is in the background, you cannot see it, you cannot type into it. 1.) Granted the following privs from sys: begin dbms_java.grant_permission ('SCOTT', 'Tags: Adult Dating, affair dating, sex dating