We have conveniently created users for Designer on Oracle for whom the password never expires.
Designer does not seem to have an option to change a user password. Our users will not get direct database access through other tools.
Now the security team has (rightly so) challenged us why the users should have never expiring passwords.
I have two questions:
1. What happens if a user tries to logon when his password is expired or is about to expire? Will they be prompted for a new password?
2. Is it possible to change the designer (Oracle, or whatever database user) password, from designer? Changing it in Oracle is of no use to me as Data Services developers will not get database access to the actual repository databases.
Thanks in advance for your help,