Re: so what are the "REAL" permissions needed for real application testing

  • From: John Kanagaraj <john.kanagaraj@xxxxxxxxx>
  • To: andy <andy@xxxxxxxxxxxxxxx>, TESTAJ3 <TESTAJ3@xxxxxxxxxxxxxx>
  • Date: Wed, 17 Nov 2010 13:09:28 -0800

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@xxxxxxxxxxxxxxx> 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
>
> http://www.wyswert.com/documentation/oracle/database/11.2/appdev.112/e10577/d_workload_replay.htm#CHDBJAAE
>
> On Wed, Nov 17, 2010 at 11:45 AM, <TESTAJ3@xxxxxxxxxxxxxx> 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 **
--
//www.freelists.org/webpage/oracle-l


Other related posts: