You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I wish the users description also could be queried by SQL with commands like
COMMENT ON USER name IS 'text'
and/or ALTER USER name SET COMMENT 'text'
It might help browsing user list in client apps (for example setting user grants when taking users from LDAP/ActiveDirectory) , it might help distinguish users created for different DBs by different APPs in inherited environments
For FB3 that probably may need security plugins API review, then the earlier the better
From what i see, there currently (as of 2.5.2rc1) is no SQL comands to *query* comments/descriptions at all, for no kind of objects, but only selecting from system tables works.
Maybe they can be implemented too.
Or maybe failed to search docs.
Submitted by: Arioch (arioch)
There is a field RDB$COMMENT in RDB$USERS.
Accessing that field in security2.fdb is no more possible.
To compensate for it, a number of user management commands was implemented: http://www.firebirdfaq.org/faq19/
I wish the users description also could be queried by SQL with commands like
COMMENT ON USER name IS 'text'
and/or ALTER USER name SET COMMENT 'text'
It might help browsing user list in client apps (for example setting user grants when taking users from LDAP/ActiveDirectory) , it might help distinguish users created for different DBs by different APPs in inherited environments
For FB3 that probably may need security plugins API review, then the earlier the better
Commits: 64b4f89 FirebirdSQL/fbt-repository@84c5aa8
The text was updated successfully, but these errors were encountered: