You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ALTER USER <username>
[PASSWORD 'password']
[FIRSTNAME 'firstname']
[MIDDLENAME 'middlename']
[LASTNAME 'lastname']
[{GRANT | REVOKE} ADMIN ROLE];
should be extended to accept context variables USER and CUREENT_USER.
ALTER USER CURRENT_USER will be handy for changing user info of current user, without need for passing username as parameter.
Also, similar to what MySQL do, ALTER USER without username can be interpreted exactly the same as ALTER USER CURRENT_USER, and change credentials of a user who is executing query.
Note. Changing of TAGS can be seen only when UserManager = Srp.
This test implies that firebird.conf contain UserManager = Legacy_UserManager, so it changes
only 'old' attributes: password, first_name, middle_name and last_name.
Test Details: Note. Changing of TAGS can be seen only when UserManager = Srp.
This test implies that firebird.conf contain UserManager = Legacy_UserManager, so it changes
only 'old' attributes: password, first_name, middle_name and last_name.
Test Details: Note. Changing of TAGS can be seen only when UserManager = Srp.
This test implies that firebird.conf contain UserManager = Legacy_UserManager, so it changes
only 'old' attributes: password, first_name, middle_name and last_name.
=>
Note. Changing of TAGS can be seen only when UserManager = Srp.
This test implies that firebird.conf contain UserManager = Legacy_UserManager, so it changes
only 'old' attributes: password, first_name, middle_name and last_name.
Submitted by: obucina (obucina)
Votes: 1
Current syntax:
ALTER USER <username>
[PASSWORD 'password']
[FIRSTNAME 'firstname']
[MIDDLENAME 'middlename']
[LASTNAME 'lastname']
[{GRANT | REVOKE} ADMIN ROLE];
should be extended to accept context variables USER and CUREENT_USER.
ALTER USER CURRENT_USER will be handy for changing user info of current user, without need for passing username as parameter.
Also, similar to what MySQL do, ALTER USER without username can be interpreted exactly the same as ALTER USER CURRENT_USER, and change credentials of a user who is executing query.
Commits: dacbc27 FirebirdSQL/fbt-repository@3666260
====== Test Details ======
Note. Changing of TAGS can be seen only when UserManager = Srp.
This test implies that firebird.conf contain UserManager = Legacy_UserManager, so it changes
only 'old' attributes: password, first_name, middle_name and last_name.
See also test for CORE5827.
The text was updated successfully, but these errors were encountered: