| How can I set HR account unlimited? [message #247101] |
Sun, 24 June 2007 02:07  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
I worry about my account HR in OraDatabase which was set account_status as EXPIRED
Additional information: I set some columns following format a20, but you see, it's not my acquirements! How do I set?
SQL> col username format a20
SQL> col account_status format a20
SQL> col expiry_date format a20
SQL> col lock_date format a20
SQL> col profile format a20
SQL> select username, account_status as "ACC", expiry_date as "EXP_D",
2 lock_date as "LOCK_D", profile
3 from dba_users
4 where username ='HR';
USERNAME ACC EXP_D LOCK_D
-------------------- -------------------------------- --------- ---------
PROFILE
--------------------
HR EXPIRED 23-JUN-07
DEFAULT
SQL>
Then, I checked profile named as DEFAULT, and I saw.
SQL> show parameter resource_limit
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
resource_limit boolean FALSE
SQL> select profile, limit
2 from dba_profiles
3 where profile ='DEFAULT';
PROFILE LIMIT
------------------------------ ----------------------------------------
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT UNLIMITED
PROFILE LIMIT
------------------------------ ----------------------------------------
DEFAULT UNLIMITED
DEFAULT UNLIMITED
DEFAULT NULL
DEFAULT UNLIMITED
DEFAULT UNLIMITED
16 rows selected.
SQL>
Following above code, this profile DEFAULT was UNLIMITED, however, and I did not understand why my account HR was locked?
How can I resolve this problem?
Thank you very much!
[Updated on: Sun, 24 June 2007 02:08] Report message to a moderator |
|
|
|
| Re: How can I set HR account unlimited? [message #247102 is a reply to message #247101] |
Sun, 24 June 2007 02:12  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | I worry about my account HR in OraDatabase which was set account_status as EXPIRED
|
You Just Installed ORACLE?
alter user hr identified by hr account unlock;
| Quote: | Additional information: I set some columns following format a20, but you see, it's not my acquirements! How do I set?
|
SQL>set line 200
| Quote: |
Following above code, this profile DEFAULT was UNLIMITED, however, and I did not understand why my account HR was locked?
|
I guess you didnt unlock during installation??
| Quote: | How can I resolve this problem?
|
ALter user hr identified by hr acount unlock;
[Updated on: Sun, 24 June 2007 02:12] Report message to a moderator |
|
|
|
|
|
| Re: How can I set HR account unlimited? [message #247104 is a reply to message #247101] |
Sun, 24 June 2007 02:24 |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Dear DreamZ: Thank you for your reply!
My OraDBMS was installed for a long time! This is Release 9.2.0.1, and OraDeveloper is Release 2 (9.0.2).
I have not regarded to HR account because I did not need to work with it, however, I have to export HR's data to a file today! Then I recognized that problem!
SQL> alter user hr account unlock;
User altered.
SQL> select username, account_status
2 from dba_users
3 where username ='HR';
USERNAME ACCOUNT_STATUS
-------------------- --------------------
HR EXPIRED
SQL>
Dear Michael: I just unlocked this account as you see! How can I try to set this account_status to be UNLIMITED or not EXPIRED?
Thank you!
[Updated on: Sun, 24 June 2007 02:28] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
