Open ibre5041 opened 3 years ago
Changes summary:
use single quotes for IDENTIFIED BY VALUES
user double quotes for IDENTIFIED BY "plaintext password", allows passwords starting with digit (and other special cases)
upper/lower case for TBS, PROFILE, etc is ignored
wanted/current are stored as a set of tuples:
set({('PASSWORD_HASH', '****'), ('PROFILE', 'default'), ('DEFAULT_TABLESPACE', 'users'), ('ACCOUNT_STATUS', 'locked')})
ALTER USER command is triggered when wanted_set is not subset of current_set
When password hash is provided and is it the same as old password hash, password is not altered. This avoids messing with various security profiles.
port number parameter type is "int"
Changes summary:
use single quotes for IDENTIFIED BY VALUES
user double quotes for IDENTIFIED BY "plaintext password", allows passwords starting with digit (and other special cases)
upper/lower case for TBS, PROFILE, etc is ignored
wanted/current are stored as a set of tuples:
set({('PASSWORD_HASH', '****'), ('PROFILE', 'default'), ('DEFAULT_TABLESPACE', 'users'), ('ACCOUNT_STATUS', 'locked')})
ALTER USER command is triggered when wanted_set is not subset of current_set
When password hash is provided and is it the same as old password hash, password is not altered. This avoids messing with various security profiles.
port number parameter type is "int"