Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> execute dbms_job
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
![]() |
![]() |