What privileges are required so that a user can view and kill a session in DBA | Kill/Trace Session
Required object grants:
GRANT SELECT ON sys.v_$sess_io TO <username>;
GRANT SELECT ON sys.v_$session TO <username>;
GRANT SELECT ON sys.v_$transaction TO <username>;
GRANT SELECT ON sys.v_$rollname TO <username>;
GRANT SELECT ON sys.V$open_cursor TO <username>;
GRANT SELECT ON sys.v_$process TO <username>;
GRANT SELECT ON sys.v$lock TO <username>;
GRANT SELECT ON sys.v$Locked_object TO <username>;
GRANT SELECT ON sys.v$sqltext_with_newlines TO <username>;
GRANT SELECT ON sys.v_$transaction TO <username>;
Required system grants:
GRANT ALTER SESSION TO <username>;
GRANT ALTER SYSTEM FROM <username>;
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy