顯示當(dāng)前連接用戶(hù)
SQL> show user??????
USER 為"SYS"
SQL>
在某個(gè)用戶(hù)下找所有的索引
selectuser_indexes.table_name, user_indexes??? .index_name,uniqueness,column_name ?
fromuser_ind_columns, user_indexes??
whereuser_ind_columns.index_name = user_indexes.index_name
anduser_ind_columns.table_name = user_indexes.table_name
orderby user_indexes.table_type, user_indexes.table_name, user_indexes.index_name,column_position;
查詢(xún)每個(gè)用戶(hù)的權(quán)限
SQL>SELECT * FROM DBA_SYS_PRIVS;
獲取有哪些用戶(hù)在使用數(shù)據(jù)庫(kù)
SQL>select username from v$session;
USERNAME
------------------------------------------------------------
MMSG
MMSG
SYS
SYS
MMSG
MMSG
MMSG
已選擇7行。
SQL>
查詢(xún)用戶(hù)擁有的權(quán)限
mmsg:oracle:mmsgdb> sqlplus / as sysdba
+SQL*Plus:Release11.1.0.6.0 - Production on Tue Feb 2215:58:54 2011
Copyright(c) 1982, 2007, Oracle.? All rightsreserved.
Connectedto:
OracleDatabase11gEnterprise Edition Release11.1.0.6.0 -64bit Production
Withthe Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>SELECT *? FROMDBA_SYS_PRIVS where grantee='MMSG';
GRANTEE??????????????????????? PRIVILEGE????????????????? ??????????????ADM
---------------------------------------------------------------------- ---
MMSG?????????????????????????? UNLIMITEDTABLESPACE???????????????????? NO
MMSG?????????????????????????? CREATE VIEW????????????????????????????? NO
MMSG??????? ???????????????????CREATE TABLE???????????????????????????? NO
MMSG?????????????????????????? CREATE SESSION?????????????????????????? NO
MMSG?????????????????????????? CREATEPROCEDURE???????????????????????? NO
MMSG?????????????????????????? CREATE SEQUENCE????????????????????????? NO
6rows selected.
SQL>
鎖用戶(hù)/用戶(hù)解鎖
鎖用戶(hù)
SQL>alter user wyz account lock;
用戶(hù)已更改肄程。
SQL>connect wyz/wyz@mmsgdb
ERROR:
ORA-28000:帳戶(hù)已被鎖定
警告:您不再連接到 ORACLE光绕。
用戶(hù)解鎖
SQL>alter user wyz account unlock;
用戶(hù)已更改。
SQL>connect wyz/wyz@mmsgdb
已連接募狂。
SQL>exit
