Issue Details (XML | Word | Printable)

Key: CORE-4503
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Alexander Peshkov
Reporter: Simonov Denis
Votes: 0
Watchers: 3
Operations

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

ISQL command SHOW USERS display only me

Created: 30/Jul/14 06:23 AM   Updated: 14/Jun/15 06:51 AM
Component/s: ISQL
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 2

Environment: Windows 7 x64, Firebird Version: WI-T3.0.0.31258 Firebird 3.0 Alpha 2, SuperServer

QA Status: Done successfully


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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 30/Jul/14 07:10 AM
One detail to discuss. (I've already thought about changing SHOW USERS, but...)
Currently isql shows users, connected to database. This set may be wider than one present in security database if you use some unrelated to sec db plugin (for example, windows trusted auth).
What do you suggest to do in that case?

Simonov Denis added a comment - 30/Jul/14 07:29 AM
I do not know the answer to this question. Will show that in this case, the query "select * from sec$users"?
Perhaps that in such cases keep the current behavior or focus on what is there on the mapping security.fdb.
In Realese Notes said "This feature depends highly on the user management plug-in. Take into an account that some options are ignored when using the legacy user management plug-in."

Alexander Peshkov added a comment - 01/Dec/14 09:47 AM
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).