I Created a user with option PASSWORD EXPIRE. Now the problem is that the user is annoyed by entering his password day afer day as it get expired when it cross grace period. I want to disable PASSWORD EXPIRE for that user. How?
i don't think there is any Oracle option as PASSWORD NOT EXPIRE or something like that. Either i have to export the user schema , drop user, again create the user without PASSWORD EXPIRE and then import into this schema. Is there any other easy solution?
Please reply urgently.
You cannot succeed if you fear to face challenges.
BE(CS) , OCP 8/8i.