Issue Details (XML | Word | Printable)

Key: CORE-3931
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Arioch
Votes: 0
Watchers: 1
Operations

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

SQL commands to query/alter users description

Created: 21/Sep/12 02:09 PM   Updated: 17/Dec/13 02:32 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 3.0 Alpha 2

Time Tracking:
Not Specified

Planning Status: Unspecified


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

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Arioch added a comment - 28/Sep/12 12:33 PM
Thanks.

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.

Alexander Peshkov added a comment - 17/Dec/13 02:32 PM
COMMENT ON USER x IS text
should be used