-
Notifications
You must be signed in to change notification settings - Fork 64
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
Add the users management per database (Node Users) #149
Labels
Comments
Jdochoa
added a commit
to Jdochoa/flamerobin
that referenced
this issue
Mar 1, 2021
- Some fixes DB Trigger, DML Trigger and DDL Trigger mariuz#48, mariuz#70, mariuz#73 and mariuz#154 - Some fixes Package implementation mariuz#55 - Unable to change Field Datatype mariuz#165 - "Functions" and "Global Temporaries" context popup menu mariuz#162 - Index node experimental. - Initial implementation node users mariuz#149
Merged
Retest result on FlameRobin 0.9.3.12: FAIL! Best Regards, |
Hi @Jdochoa Do you have any expectations of implementing this feature? Thanks in advance, |
hi @luronumen , i work in this in break. maybe it's ready for January. ./jo |
You are the Guy @Jdochoa ! Thank you very much! |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Since version 3, the Firebird authentication system has evolved considerably, allowing users to be managed through SQL commands in addition to creating users using various plugins (Legacy_UserManager, Srp, etc.) and mappings.
In Firebird 3.0 groups of users are allowed per database and no longer per server as it is currently implemented in FlameRobin.
Please add the users management per database by adding the Users node for each database registered with FlameRobin:
And use the following query to identify the database users:
SELECT SEC$USERS.SEC$USER_NAME AS USER_NAME, SEC$USERS.SEC$FIRST_NAME AS FIRST_NAME, SEC$USERS.SEC$MIDDLE_NAME AS MIDDLE_NAME, SEC$USERS.SEC$LAST_NAME AS LAST_NAME, SEC$USERS.SEC$ACTIVE AS "ACTIVE", SEC$USERS.SEC$ADMIN AS "ADMIN", SEC$USERS.SEC$DESCRIPTION AS DESCRIPTION, SEC$USERS.SEC$PLUGIN "PLUGIN", SEC$USER_ATTRIBUTES.SEC$KEY AS "KEY", SEC$USER_ATTRIBUTES.SEC$VALUE AS "VALUE" FROM SEC$USERS LEFT JOIN SEC$USER_ATTRIBUTES ON SEC$USERS.SEC$USER_NAME=SEC$USER_ATTRIBUTES.SEC$USER_NAME AND SEC$USERS.SEC$PLUGIN=SEC$USER_ATTRIBUTES.SEC$PLUGIN ORDER BY USER_NAME, "PLUGIN";
The text was updated successfully, but these errors were encountered: