e.g. for internal security reasons you need to change the Oracle Schema Password from the Adminconsole using some security rules (minimum length, use capital letters and special characters.).
Are ther any restrictions (character restrictions, max. lenght) to set the schema password.
Solution
There are no restrictions for eMServer user passwords, besides the limit of 255 characters.
For Oracle schema passwords general Oracle rules apply (more details here
Database Object Names and Qualifiers)
- Nonquoted identifiers can contain only alphanumeric characters from your database character set and the underscore (_), dollar sign ($), and pound sign (#).
- Quoted identifiers can contain any characters and punctuations marks as well as spaces.
- However, neither quoted nor nonquoted identifiers can contain double quotation marks (") or the null character (\0).
A nonquoted password is for example:
Test_$Test
A quoted password is:
"Test!$!Test"
For existing Oracle Schema you can change the user password from SQLplus to be a quoted identifier.
Then you can update the password for eMServer using AdminConsole \ Association.
There is limitation that AdminConsole does not allow a user to be created with quoted password.
Also Schema Actions like Refresh Schema, etc. may not work.
Notes and References
Currently R&D investigating the limitations.
Hardware/Software Configuration
Platform: all
OS: n/a
OS Version: n/a
Product: TECNOMATIX
Application: EM-SERVER
Version: V_UNKNOWN
Function: DATABASE
Ref: 002-8017334