--revoke select on sys.gv_$locked_object from tsql; --revoke select on sys.gv_$session from tsql; --grant select on sys.gv_$locked_object to tsql with grant option; --grant select on sys.gv_$session to tsql with grant option; CREATE OR REPLACE VIEW tsql.v_table_lock AS SELECT lo.inst_id, lo.session_id, s.serial#, lo.oracle_username, (SELECT object_name FROM all_objects o WHERE o.object_id = lo.o..