Home » RDBMS Server » Server Administration » How can I set HR account unlimited?
How can I set HR account unlimited? [message #247101] Sun, 24 June 2007 02:07 Go to next message
trantuananh24hg
Messages: 668
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 Go to previous messageGo to next message
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 #247103 is a reply to message #247101] Sun, 24 June 2007 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I set some columns following format a20, but you see, it's not my acquirements!

For instance, you set the column "account_status" but there is no column "account_status" in your query result there is a column "ACC".
Guess how to fix it.

Quote:
I did not understand why my account HR was locked?

The account is locked at installation time.

Regards
Michel
Re: How can I set HR account unlimited? [message #247104 is a reply to message #247101] Sun, 24 June 2007 02:24 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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

Re: How can I set HR account unlimited? [message #247106 is a reply to message #247104] Sun, 24 June 2007 02:31 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
ALTER USER HR IDENTIFIED BY HR;

I am almost sleepy..

[Updated on: Sun, 24 June 2007 02:32]

Report message to a moderator

Re: How can I set HR account unlimited? [message #247108 is a reply to message #247104] Sun, 24 June 2007 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I should say account is lock and password expire at installation time.

Regards
Michel

Re: How can I set HR account unlimited? [message #247110 is a reply to message #247108] Sun, 24 June 2007 02:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I guess we have to show him the password windows when it occur during installtion by PICTURE.
Re: How can I set HR account unlimited? [message #247115 is a reply to message #247101] Sun, 24 June 2007 04:51 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you!
I have unlocked it following your guide!
I am sorry, my English is not well to understand everything.
Thank again!

[Updated on: Sun, 24 June 2007 05:23]

Report message to a moderator

Previous Topic: Here is How to Identify Performance Bottleneck
Next Topic: Save Pfile Permanently
Goto Forum:
  


Current Time: Sat Dec 03 06:01:19 CST 2016

Total time taken to generate the page: 0.16156 seconds