Skip to content
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

SQL commands to query/alter users description [CORE3931] #1446

Closed
firebird-automations opened this issue Sep 21, 2012 · 5 comments
Closed

SQL commands to query/alter users description [CORE3931] #1446

firebird-automations opened this issue Sep 21, 2012 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Arioch (arioch)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

COMMENT ON USER x IS text
should be used

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants