Re: How To grant execute to user on DBMS_LOGMNR package

Hannah, which version of database are you playing with as that depends on who can run it and/or what permissions they need to run it.

joe

johanna.doran_at_sungard.com wrote:

> Hi,
>
>
>
> I would like to grant the ability to a user to run logminer. I
> tried granting execute on both dbms_logmnr and dbms_logmnr_d to the
> user to no avail. SQLPlus still requests for it to be declared (Ie.
> its not seeing it). I have even tried qualifying the package Ie.
> sys.dbms_logmnr when trying to execute?
>
>
>
> All the documentation I see and all things on the net all run it
> as SYS. Any suggestions?
>
>
>
> Thanks,
>
>
>
> Hannah
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).