Oracle user unlock, oracle unlock

Source: Internet
Author: User

Oracle user unlock, oracle unlock

Connect first

SQL * Plus: Release 12.1.0.2.0 Production on Thursday February 12 15:40:422015

Copyright (c) 1982,201 4, Oracle. All rights reserved.

Enter the User name: system

Enter the password:

Last Successful Logon Time: Thursday, December 31, 2015 10:26:40 +

Connect:

Oracle Database 12c Enterprise EditionRelease 12.1.0.2.0-64bit Production

With the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing opt

Ions

// Wake up and format the corresponding columns for observation

SQL> column username format a20

SQL> column account_status format a20

SQL> set pagesize 400

// Enter the following select statement to query the user and status information from dba_users.

SQL> select username, account_status fromdba_users

USERNAME ACCOUNT_STATUS

----------------------------------------

C ## TEST OPEN

C ## SCOTT OPEN

ORACLE_OCM EXPIRED & LOCKED

Ojvmsys expired & LOCKED

Syskm expired & LOCKED

XS $ null expired & LOCKED

Gsmcatuser expired & LOCKED

Mddata expired & LOCKED

Sysbackup expired & LOCKED

Dip expired & LOCKED

Sysdg expired & LOCKED

APEX_PUBLIC_USER EXPIRED & LOCKED

SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED

R

 

SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED

R

 

Gsmuser expired & LOCKED

Audsys expired & LOCKED

C ## USER1 OPEN

FLOWS_FILES EXPIRED & LOCKED

Dvf expired & LOCKED

Mdsys expired & LOCKED

Ordsys expired & LOCKED

Dbsnmp expired & LOCKED

Wmsys expired & LOCKED

APEX_040200 EXPIRED & LOCKED

Appqossys expired & LOCKED

Gpressmin_internal EXPIRED & LOCKED

Orddata expired & LOCKED

Ctxsys expired & LOCKED

Anonymous expired & LOCKED

Xdb expired & LOCKED

Ordplugins expired & LOCKED

Dvsys expired & LOCKED

SI_INFORMTN_SCHEMA EXPIRED & LOCKED

Olapsys expired & LOCKED

Lbacsys expired & LOCKED

Outln expired & LOCKED

SYSTEM OPEN

SYS OPEN

38 rows have been selected.

As shown above, if account_status of username is open, it indicates that the user has been unlocked. If account_status of username is EXPIRED, it indicates that the user has EXPIRED. If account_status of username is locked, indicates that the user is locked. You cannot log on to an expired or locked account. You must first unlock the account.

// Next we will unlock the outln user

SQL> alter user outln account unlock;

The user has changed.

// Specify a password for the user

SQL> alter user outln identified byadmin;

The user has changed.

// Query the user

SQL> select username, account_status fromdba_users;

USERNAME ACCOUNT_STATUS

----------------------------------------

C ## TEST OPEN

C ## SCOTT OPEN

ORACLE_OCM EXPIRED & LOCKED

Ojvmsys expired & LOCKED

Syskm expired & LOCKED

XS $ null expired & LOCKED

Gsmcatuser expired & LOCKED

Mddata expired & LOCKED

Sysbackup expired & LOCKED

Dip expired & LOCKED

Sysdg expired & LOCKED

APEX_PUBLIC_USER EXPIRED & LOCKED

SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED

R

SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED

R

Gsmuser expired & LOCKED

Audsys expired & LOCKED

C ## USER1 OPEN

FLOWS_FILES EXPIRED & LOCKED

Dvf expired & LOCKED

Mdsys expired & LOCKED

Ordsys expired & LOCKED

Dbsnmp expired & LOCKED

Wmsys expired & LOCKED

APEX_040200 EXPIRED & LOCKED

Appqossys expired & LOCKED

Gpressmin_internal EXPIRED & LOCKED

Orddata expired & LOCKED

Ctxsys expired & LOCKED

Anonymous expired & LOCKED

Xdb expired & LOCKED

Ordplugins expired & LOCKED

Dvsys expired & LOCKED

SI_INFORMTN_SCHEMA EXPIRED & LOCKED

Olapsys expired & LOCKED

Lbacsys expired & LOCKED

OUTLN OPEN

SYSTEM OPEN

SYS OPEN

38 rows have been selected.

As shown above, outln is displayed as open.

// Test the connection

SQL> connect outln/admin

Connected.

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.