oracle用户解锁

红太狼 2022-03-24 19:16 242阅读 0赞

查看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**][sys_TESTDB]**> alter user sh account unlock; --解开LOCKED**

[**sys@TESTDB**][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.

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！[https://blog.csdn.net/jiangjunshow][https_blog.csdn.net_jiangjunshow]

[sys_TESTDB]: mailto:sys@TESTDB
[https_blog.csdn.net_jiangjunshow]: https://blog.csdn.net/jiangjunshow/article/details/77338485