Remove Complex Passwords in Smart Suite

Receiving Oracle Error in Smart Center When Creating Passwords for Listings.

When creating a listing record in Smart Center, you may see an Oracle error at the bottom of your screen. When lookinfor more info it is referring to the password needing a certain number of numbers, capital letters, special characters, etc.

This normally occurs after an upgrade and seems to be the default setting within the database.

Resolution:

For Smart Suite 5.x - To resolve this issue, log into SQL Plus and use the following:

connect / as sysdba 

alter profile amcom limit PASSWORD_VERIFY_FUNCTION null;  

commit;

For Smart Suite 7.x - To resolve this issue, log into SQL Plus and use the following:

sqlplus / as sysdba 

alter profile amcom limit PASSWORD_VERIFY_FUNCTION default;  

commit;