Expired Account Set VALID UNTIL

Posted on 2008-06-10
Medium Priority
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'
ALTER USER test VALID UNTIL 'infinity';
Question by:9413systems
LVL 29

Expert Comment

ID: 21754020
MIgrate to Oracle 10g.
LVL 74

Expert Comment

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


Author Comment

ID: 21762105
The ALTER USER command alters the user.  I use this all the time time unlock accounts set passwords..etc.
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

LVL 74

Expert Comment

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?

LVL 23

Accepted Solution

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.


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

Expert Comment

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.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
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 how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

622 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