Pre-fabricated users in oracle are enabled

Pre-fabricated users in oracle are enabled

Some ORACLE users are premade and useful, but they are locked during initialization. We need to manually enable it.
SQL * Plus: Release 10.2.0.1.0-Production on Tuesday April 9 20:02:02 2013

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set linesize 180
SQL> select username, account_status from dba_users;
We enable HR users

SQL> alter user hr account unlock;


The user has changed.

SQL> alter user hr identified by hr;

The user has changed.


SQL> select username, account_status from dba_users where username like '% HR % ';


USERNAME ACCOUNT_STATUS
--------------------------------------------------------------
HR OPEN
Check that the user has enabled

Now you can view the table in it.
Connected.
SQL> select * from tab;


TNAME TABTYPE CLUSTERID
-----------------------------------------------
REGIONS TABLE
COUNTRIES TABLE
LOCATIONS TABLE
Orders ments TABLE
JOBS TABLE
EMPLOYEES TABLE
JOB_HISTORY TABLE
EMP_DETAILS_VIEW VIEW


Eight rows have been selected.


SQL> select * from regions;


REGION_ID REGION_NAME
-----------------------------------
1 Europe
2 Americas
3 Asia
4 Middle East and Africa