Issue Details (XML | Word | Printable)

Key: CORE-3365
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: obucina
Votes: 1
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Extend syntax for ALTER USER CURRENT_USER

Created: 28/Feb/11 01:21 AM   Updated: 16/May/18 06:53 AM
Component/s: Engine
Affects Version/s: 2.5.0
Fix Version/s: 3.0 Alpha 2

Planning Status: Considered for inclusion
Target: 3.0 Beta 1
QA Status: Done successfully
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 CORE-5827.


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 17/Dec/13 04:25 PM
Syntax
ALTER CURRENT USER
is implemented. No MySQL-style shortcut.