permissions

Golden Gate - OS User Permissions on *nix - DBA vs ETL Admin

Submitted by dave on Mon, 11/14/2011 - 13:11

Seems like Golden Gate is following me around. I used their tools in 2005 to replicate from OLTP databases to a central reporting database for my previous employer. Now that Oracle bought them the buzz in my current company is to leave Oracle's multiple and complicated incarnations of replication technologies in the dust and try moving forward with GG. Fine with me, I like the product, not a fan of the licensing as I think Oracle has been on the lagging side of vendor supplied replication tools, but hey what do I know, I just arrange zeroes and ones for a living.

Tags: 
permissions
Golden Gate

Permissions for Autotrace

Submitted by dave on Tue, 01/12/2010 - 15:06

If you want to run AutoTrace using Toad using a non sys or system user, give your user the following select privileges:

grant select on v_$session to &traceuser.;
grant select on v_$sesstat to &traceuser.;
grant select on v_$statname to &traceuser.;

Alternately you can run $ORACLE_HOME/sqlplus/admin/plustrce.sql and then grant the PLUSTRACE role to the user that needs to run AutoTrace.

-Dave

Tags: 
autotrace
toad
permissions
Subscribe to permissions