Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Extend syntax for ALTER USER CURRENT_USER [CORE3365] #3731

Closed
firebird-automations opened this issue Feb 28, 2011 · 6 comments
Closed

Extend syntax for ALTER USER CURRENT_USER [CORE3365] #3731

firebird-automations opened this issue Feb 28, 2011 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Open [ 1 ]

Target: 3.0 Beta 1 [ 10332 ]

Planning Status: Unspecified => Considered for inclusion

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Syntax
ALTER CURRENT USER
is implemented. No MySQL-style shortcut.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

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.

See also test for CORE5827.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants