9413systems
asked on
Expired Account Set VALID UNTIL
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';
ALTER USER test VALID UNTIL 'Jan 31 2340'
OR
ALTER USER test VALID UNTIL 'infinity';
MikeOM_DBA
MIgrate to Oracle 10g.
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
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
ASKER
The ALTER USER command alters the user. I use this all the time time unlock accounts set passwords..etc.
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.