鎖用戶
alter user UCR_CEN1 ACCOUNT LOCK;
alter user UCR_CEN1 ACCOUNT UNLOCK;
輸錯密碼無限制
alter profile default limit failed_login_attempts unlimited;
select * from DBA_PROFILES where resource_name='FAILED_LOGIN_ATTEMPTS';
用戶密碼重試次數(shù)
select name, lcount from sys.user$ where name like 'U%';
重置密碼
alter user scott identified by 123456;
查看當(dāng)前用戶具有哪些系統(tǒng)權(quán)限
select * from user_sys_privs;
查看當(dāng)前用戶具有哪些對象權(quán)限
select * frm user_tab_privs;
查看當(dāng)前用戶具有哪些控制到列的權(quán)限
select * from user_col_privs;
用戶賦權(quán)
grant create table,unlimited tablespace to public
grant all on mywangwu to public
查看用戶清單
select user_id,USERNAME,ACCOUNT_STATUS,CREATED from dba_users order by CREATED
DROP用戶下所有對象
drop user UOP_UIF2 cascade;
用戶視圖
select * from all_users; --查看所用用戶
select * from all_tables; --查看所有表
select * from user_tables; --查看當(dāng)前用戶下有那些 表
select * from user_views; --查看當(dāng)前用戶下有那些 試圖
select constraint_name,table_name from user_constraints; --查看當(dāng)前用戶下有那些 約束采桃，已經(jīng)所對應(yīng)的表
select * from dictionary where table_name like 'USER%';
select * from user_sys_privs; --查看當(dāng)前用戶具有哪些系統(tǒng)權(quán)限
select * from user_tab_privs; --查看當(dāng)前用戶具有哪些對象權(quán)限
select * from user_col_privs; --查看當(dāng)前用戶具有哪些控制到列的權(quán)限
查看表權(quán)限
select * from dba_tab_privs where owner='UCR_CEN1';
