?
Solved

Expired Account Set VALID UNTIL

Posted on 2008-06-10
9
Medium Priority
?
1,747 Views
Last Modified: 2013-12-19
I want to have an account that will never expire.  I want to do this without creating a profile.  Looks like the below command works in Oracle 9 but not in Oracle 8.  Any recommendations for an ALTER USER command in Oracle 8 that will give me the option to set an expire date?

ALTER USER test VALID UNTIL 'Jan 31 2340'
OR
ALTER USER test VALID UNTIL 'infinity';
0
Comment
Question by:9413systems
6 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 21754020
MIgrate to Oracle 10g.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 21756228
what is this alter user command?  Are you sure you have the syntax correct?

I looked in the oracle 8, 9 and 10 documentation and also tried running it myself on 8i ,9i,10g and 11g all returned

ORA-00922: missing or invalid option



0
 
LVL 1

Author Comment

by:9413systems
ID: 21762105
The ALTER USER command alters the user.  I use this all the time time unlock accounts set passwords..etc.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Expert Comment

by:sdstuber
ID: 21762362
yes, I understand that,
I know what "alter user" is and how to use it.

I don't know what "ALTER USER test VALID UNTIL 'Jan 31 2340'"  is

you said that command works in 9i.
but I wasn't able to run that command nor could I find any supporting documentation that such options exist.

If it does work,  how?  and what does it do?

0
 
LVL 23

Accepted Solution

by:
David earned 2000 total points
ID: 22015674
The desired syntax does not exist.  However, to stay in 8i w/o creating a new profile, you have an option to set the default (mandatory) profile as having non-expiring accounts.  NOTE that in order to have accounts with expiring passwords, you must create a new profile and assign those users to that new profile -- which BTW is very, very, simple.

>ALTER PROFILE DEFAULT PASSWORD_LIFE_TIME UNLIMITED;

Reference: http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/users_secure003.htm#sthref432
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 22167149
in the absence of any input from the asker, I think dvz's answer (22015674)  is the best.

It's contrary to what the user asked for, but does in fact solve the problem, especially since there isn't any such syntax as indicated in the question.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses
Course of the Month15 days, 13 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question