Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> execute dbms_job

execute dbms_job

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: Sat, 21 Jul 2001 21:37:25 GMT
Message-ID: <9inhck$347@dispatch.concentric.net>

I use this script to create users for our application. My problem is that 'FIT_DBA' can execute procedures in dbms_job but 'FIT' cannot. Why? It looks like 'FIT' is granted 'EXECUTE ANY LIBRARY' via the FIT_USER role.

CREATE USER FIT_DBA IDENTIFIED BY xxx
  DEFAULT TABLESPACE USER_DATA
  TEMPORARY TABLESPACE TEMP; GRANT "DBA" TO "FIT_DBA"; CREATE ROLE FIT_USER; GRANT DELETE ANY TABLE, EXECUTE ANY LIBRARY, EXECUTE ANY PROCEDURE,

      INSERT ANY TABLE, UPDATE ANY TABLE, SELECT ANY TABLE,
      SELECT ANY SEQUENCE, CONNECT TO "FIT_USER";

CREATE USER FIT IDENTIFIED BY xxx
  DEFAULT TABLESPACE USER_DATA
  TEMPORARY TABLESPACE TEMP; GRANT "FIT_USER" TO "FIT"; COMMIT;

--
Jim Poe (jpoe_at_fulcrumit.com)
Received on Sat Jul 21 2001 - 16:37:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US