ORACLE给用户赋权限是用户可以查看锁表，杀表

命令如下：

-- Grant/Revoke object privileges 
grant select on DBA_OBJECTS to USERNAME;
grant select on GV_$LOCKED_OBJECT to USERNAME;
grant select on GV_$SESSION to USERNAME;
grant select on GV_$SQLAREA to USERNAME;
grant select on V_$ACCESS to USERNAME;
grant select on V_$DATABASE to USERNAME;
grant select on V_$LOCK to USERNAME;
grant select on V_$SESSION to USERNAME;
grant select on V_$SESSTAT to USERNAME;
grant select on V_$SQL to USERNAME;
grant select on V_$STATNAME to USERNAME;
-- Grant/Revoke role privileges 
grant connect to USERNAME;
grant resource to USERNAME;
-- Grant/Revoke system privileges 
grant alter system to USERNAME;