Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Expired user

Daniel SchunkJan 31 2020 — edited Feb 7 2020

Hello to the community,

a user account is entered in the table dba_users by a program.

This user has expired - the program accessing the Oracle database is causing an error (ORA-00942: table or view does not exist).

Can I set the account status to Open or raise the Expiry Date via SQL?

For a hint I thank you in advance!

Regards, Daniel

Comments
Post Details
Added on Jan 31 2020
11 comments
4,953 views