homme.io

Clean.Precise.Quick.

PL/SQL Developer: Session browser - what privileges are needed?

GRANT SELECT ON V_$SESSION TO USER;
GRANT SELECT ON V_$SQLTEXT TO USER;
GRANT SELECT ON V_$SQLTEXT_WITH_NEWLINES <\t>TO USER;
GRANT SELECT ON V_$OPEN_CURSOR TO USER;
GRANT SELECT ON V_$LOCK TO USER;
GRANT SELECT ON V_$SESSTAT TO USER;
GRANT SELECT ON V_$STATNAME TO USER;