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
ISQL command SHOW USERS display only me [CORE4503] #4822
Comments
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Commented by: @AlexPeshkoff One detail to discuss. (I've already thought about changing SHOW USERS, but...) |
Commented by: @sim1984 I do not know the answer to this question. Will show that in this case, the query "select * from sec$users"? |
Modified by: @dyemanovRegression: 3.0 Alpha 2 [ 10560 ] |
Commented by: @AlexPeshkoff ISQL now displays both users logged in into database and present in security database. Current user (as before) is marked with '#' sign. Users logged but not present in security database are marked with '-' sign. Also number of connections for each user is shown (may be zero when user is defined in security database but not logged in). |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Beta 2 [ 10586 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @sim1984
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:test' user 'sysdba' password 'masterkey';
Database: 'localhost:test', User: sysdba
SQL> show users;
Users in the database
# SYSDBA
SQL> set list on;
SQL> select * from sec$users;
SEC$USER_NAME SYSDBA
SEC$FIRST_NAME <null>
SEC$MIDDLE_NAME <null>
SEC$LAST_NAME <null>
SEC$ACTIVE <true>
SEC$ADMIN <false>
SEC$DESCRIPTION <null>
SEC$USER_NAME TEST
SEC$FIRST_NAME <null>
SEC$MIDDLE_NAME <null>
SEC$LAST_NAME <null>
SEC$ACTIVE <true>
SEC$ADMIN <false>
SEC$DESCRIPTION <null>
Since FB3 appeared pseudo table sec$users, you can use its commands to show users, rather than service api now.
Command will show users could be more. In addition to the user name in the same output FIRST_NAME, MIDDLE_NAME, LAST_NAME, ACTIVE and ADMIN columns.
Commits: 5a896e2 FirebirdSQL/fbt-repository@abae9cc
The text was updated successfully, but these errors were encountered: