查看oracle实例有哪些用户？ 涉及的表为dba_users [oracle@rtest ~]$ sqlplus /nologsql*plus: release 11.2.0.3.0 production on mon sep 2 11:05:49 2013copyright (c) 1982, 2011, oracle. all rights reserved.idle conn /as sysdbaconnected.sys@testdb
查看oracle实例有哪些用户？
涉及的表为dba_users
[oracle@rtest ~]$ sqlplus /nologsql*plus: release 11.2.0.3.0 production on mon sep 2 11:05:49 2013copyright (c) 1982, 2011, oracle. all rights reserved.idle> conn /as sysdbaconnected.sys@testdb> desc dba_users name null? type ----------------------------------------------------- -------- ------------------------------------ username not null varchar2(30) user_id not null number password varchar2(30) account_status not null varchar2(32) lock_date date expiry_date date default_tablespace not null varchar2(30) temporary_tablespace not null varchar2(30) created not null date profile not null varchar2(30) initial_rsrc_consumer_group varchar2(30) external_name varchar2(4000) password_versions varchar2(8) editions_enabled varchar2(1) authentication_type varchar2(8)
查看用户状态：
sys@testdb> select username,account_status from dba_users;username account_status------------------------------ --------------------------------sys opensystem openoutln expired & lockedmgmt_view expired & lockedflows_files expired & lockedmdsys expired & lockedordsys expired & lockedexfsys expired & lockeddbsnmp expired & lockedwmsys expired & lockedappqossys expired & lockedapex_030200 expired & lockedowbsys_audit expired & lockedorddata expired & lockedctxsys expired & lockedanonymous expired & lockedsysman expired & lockedxdb expired & lockedordplugins expired & lockedowbsys expired & lockedsi_informtn_schema expired & lockedolapsys expired & lockedscott expired & lockedoracle_ocm expired & lockedxs$null expired & lockedbi expired & lockedpm expired & lockedmddata expired & lockedix expired & lockedsh expired & lockeddip expired & lockedoe expired & lockedapex_public_user expired & lockedhr expired & lockedspatial_csw_admin_usr expired & lockedspatial_wfs_admin_usr expired & locked36 rows selected.
比如解锁sh账户，sh账户为ocp考试需要用到的用户，sh账户里涉及的多张表在ocp有涉及考试。
目前sh的账户的状态为：expired & locked
用以下命令给sh账户解锁：
sys@testdb> alter user sh account unlock; --解开locked
sys@testdb> alter user sh identified by sh;--解开expired
sys@testdb> alter user sh account unlock;user altered.sys@testdb> select username,account_status from dba_users;username account_status------------------------------ --------------------------------sys opensystem opensh expiredoutln expired & lockedmgmt_view expired & lockedflows_files expired & lockedmdsys expired & lockedordsys expired & lockedexfsys expired & lockeddbsnmp expired & lockedwmsys expired & lockedappqossys expired & lockedapex_030200 expired & lockedowbsys_audit expired & lockedorddata expired & lockedctxsys expired & lockedanonymous expired & lockedsysman expired & lockedxdb expired & lockedordplugins expired & lockedowbsys expired & lockedsi_informtn_schema expired & lockedolapsys expired & lockedscott expired & lockedoracle_ocm expired & lockedxs$null expired & lockedbi expired & lockedpm expired & lockedmddata expired & lockedix expired & lockeddip expired & lockedoe expired & lockedapex_public_user expired & lockedhr expired & lockedspatial_csw_admin_usr expired & lockedspatial_wfs_admin_usr expired & locked36 rows selected.sys@testdb> alter user sh identified by sh;user altered.sys@testdb> select username,account_status from dba_users;username account_status------------------------------ --------------------------------sys opensystem opensh openoutln expired & lockedmgmt_view expired & lockedflows_files expired & lockedmdsys expired & lockedordsys expired & lockedexfsys expired & lockeddbsnmp expired & lockedwmsys expired & lockedappqossys expired & lockedapex_030200 expired & lockedowbsys_audit expired & lockedorddata expired & lockedctxsys expired & lockedanonymous expired & lockedsysman expired & lockedxdb expired & lockedordplugins expired & lockedowbsys expired & lockedsi_informtn_schema expired & lockedolapsys expired & lockedscott expired & lockedoracle_ocm expired & lockedxs$null expired & lockedbi expired & lockedpm expired & lockedmddata expired & lockedix expired & lockeddip expired & lockedoe expired & lockedapex_public_user expired & lockedhr expired & lockedspatial_csw_admin_usr expired & lockedspatial_wfs_admin_usr expired & locked36 rows selected.
查看sh用户有哪些表？
sh@test0924> select * from tab;tname tabtype clusterid------------------------------ ------- ----------1_emp tablebin$51xuts/ltcdgqweaah/bla==$0 tablecal_month_sales_mv tablechannels tablecosts tablecountries tablecustomers tabledimension_exceptions tabledr$sup_text_idx$i tabledr$sup_text_idx$k tabledr$sup_text_idx$n tabledr$sup_text_idx$r tableemp_1 tableemp_2 tableemp_3 tablefweek_pscat_sales_mv tableinvoice tablenew_sales tableprice_list tableproducts tableprofits viewpromotions tablesales tablesales_transactions_ext tablesupplementary_demographics tabletimes tabletransactions tabletransactions1 table28 rows selected.