create user web_hgz identified by admin123;User created.SQL> col username format a10; --col為column縮寫,fo..."/>
您好,登錄后才能下訂單哦!
1、用戶創(chuàng)建/刪除
創(chuàng)建
SQL> create user web_hgz identified by admin123;
User created.
SQL> col username format a10; --col為column縮寫,format a10指定格式寬度為10個(gè)字符
SQL> col account_status format a15;
SQL> select username, account_status, lock_date, expiry_date from dba_users where username = 'web_hgz';
USERNAME ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
---------- --------------- ------------------- -------------------
web_hgz OPEN
刪除
SQL> drop user“name”cascade;
2、修改用戶密碼
SQL> alter user HR identified by admin123;
修改前:
SQL> select username,account_status,lock_date, expiry_date from dba_users where username ='HR';
USERNAME ACCOUNT_STATUS LOCK_DATE EXPIRY_DA
---------- --------------- --------- ---------
HR EXPIRED 29-NOV-15
修改后:
SQL> select username,account_status,lock_date, expiry_date from dba_users where username ='HR';
USERNAME ACCOUNT_STATUS LOCK_DATE
------------------------------ -------------------------------- ---------
EXPIRY_DA
---------
HR OPEN
3、 解除用戶鎖定
SQL> alter user hr account unlock;
User altered.
SQL> select a.username, a.account_status, a.lock_date from dba_users a where a.username = 'HR';
USERNAME ACCOUNT_STATUS LOCK_DATE
---------- -------------------------------- -------------------
HR OPEN
4、oracle用戶登陸失敗次數(shù)限制修改
a.查詢密碼連續(xù)輸入出錯(cuò)的最大次數(shù),超過該值則鎖定該帳號:
SQL> select * from dba_profiles s where s.profile='DEFAULT' and resource_name='FAILED_LOGIN_ATTEMPTS'; //FAILED_LOGIN_ATTEMPTS表示出錯(cuò)最大次數(shù)
b.修改登陸失敗限制次數(shù)
SQL>alter profile default limit failed_login_attempts unlimited; //表示不受限
SQL>alter profile default limit failed_login_attempts 3; //表示限制次數(shù)為3次
顯示效果:
[oracle@localhost ~]$ sqlplus hr/admin123
ERROR:
ORA-28000: the account is locked
5、賦予用戶表空間權(quán)限
SQL>alter user ittbank default tablespace ittbank;
6、授予用戶管理權(quán)限:
grant connect,resource,dba to ittbank ;
7、查看當(dāng)前用戶的角色
select * from user_role_privs;
select * from session_privs;
8、查看當(dāng)前用戶的系統(tǒng)權(quán)限和表級權(quán)限
select * from user_sys_privs;
select * from user_tab_privs;
9、查詢用戶表
select name from dba_users;
10、顯示當(dāng)前用戶
show user;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。