Re: execute dbms_job

"Jim Poe" <jpoe_at_fulcrumit.com> wrote in message news:9inhck$347_at_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)
>
>

It
> looks like 'FIT' is granted 'EXECUTE ANY LIBRARY' via the *FIT_USER role*

So not *directly* (and it also should be execute any procedure, IMO, but please reconsider before assigning such excessive privs)
>

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sat Jul 21 2001 - 16:37:38 CDT