For this I have suggested to client that we have DBA_Users and user_users view and in that we have Expiry date col.

And add a col. named Ora_expiry_date in ur table where u have stored ur Application username, passward. and update this col. with user_users expiry date col. by this u will have same expire date for Oracle users and Application software user.

But they r not convienced. They want it should be done implecitly in Aplication as it is implecitly done in Oracle. Means when message appears for oracle user the same message will appear for application user.

Any soloution please.