2014-07-07-2.sql

botang

select u.username, u.account_status
from dba_users u  where username in ('HR','U1','OPS$ORACLE', 'SYS');
;

alter user u1 account lock;

grant connect to u1;

alter user u1 account unlock;

alter user u1 password expire;


-----
select    distinct  sp.privilege   from dba_sys_privs sp   order by 1  ;

select  * from dba_sys_privs sp where sp.grantee='U1';

select  * from dba_role_privs  rp where rp.grantee='U1';

select  * from dba_tab_privs  tp where tp.grantee='U1';
---
  grant select any table to u1;
revoke select any table from u1;