Re: so what are the "REAL" permissions needed for real application testing
Date: Wed, 17 Nov 2010 16:15:10 -0500
Message-ID: <OF12EAE8A6.DEAB2FBB-ON852577DE.0074AFB9-852577DE.0074BEE3_at_lnotes-gw.ent.nwie.net>
Yes i'm documentring the gotchas as I go and metalink has a start on a doc about possible problems.
joe
Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead (Work) 614-677-1668
(Cell) 614-312-6715
From:
John Kanagaraj <john.kanagaraj_at_gmail.com>
To:
andy <andy_at_oracledepot.com>, TESTAJ3 <TESTAJ3_at_nationwide.com>
Cc:
Oracle-L <Oracle-L_at_freelists.org>
Date:
11/17/2010 04:13 PM
Subject:
Re: so what are the "REAL" permissions needed for real application testing
Sent by:
oracle-l-bounce_at_freelists.org
Hi Joe et al,
So do you have any success stories for RAT? As I read through these emails, I assume this is for the Capture/Replay portion? Do you have some gotchas, real experiences to share?
John
On Wed, Nov 17, 2010 at 8:59 AM, Andy Klock <andy_at_oracledepot.com> wrote:
> Minimally you need:
>
> EXECUTE ON DBMS_WORKLOAD_CAPTURE
> EXECUTE ON DBMS_WORKLOAD_REPLAY
> CREATE SESSION
> CREATE ANY DIRECTORY
> SELECT_CATALOG_ROLE
> BECOME USER
>
>
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_workload_capture.htm#CHDEDGGH
>
> On Wed, Nov 17, 2010 at 11:45 AM, <TESTAJ3_at_nationwide.com> wrote:
>>
>> I believe I've gotten both a capture and replay with OUT needing the
DBA
>> role.
>>
>> Does anyone else have any feedback?
>>
>> thanks, joe
>>
>> _______________________________________
>> Joe Testa, Oracle Certified Professional
>> Senior Engineering & Administration Lead
>> (Work) 614-677-1668
>> (Cell) 614-312-6715
>>
>>
>
>
-- John Kanagaraj <>< http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 17 2010 - 15:15:10 CST