ISQL command SHOW USERS display only me
---------------------------------------
Key: CORE-4503
URL: http://tracker.firebirdsql.org/browse/CORE-4503
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0 Alpha 2
Environment: Windows 7 x64, Firebird Version: WI-T3.0.0.31258 Firebird
3.0 Alpha 2, SuperServer
Reporter: Simonov Denis
Priority: Minor
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
