Add field in SEC$USERS reflecting whether a user has RDB$ADMIN role in security
database
----------------------------------------------------------------------------------------
Key: CORE-4469
URL: http://tracker.firebirdsql.org/browse/CORE-4469
Project: Firebird Core
Issue Type: Improvement
Components: Security
Reporter: Robert
Priority: Minor
I like to request a new field in SEC$USERS that reflects whether a user has the
RDB$ADMIN role in the security database (as a result of CREATE USER GRANT ADMIN
ROLE).
Suggested names for this new field: SEC$ADMIN_ROLE or SEC$ADMIN, value 0/1 or
boolean.
This is the only user info missing now in sec$users, that can be obtained by
the service manager (isc_action_svc_display_user_adm).
Note: special consideration is needed for user SYSDBA because this user is of
course an administrator, but has not the RDB$ADMIN role been assigned in the
security database. I suggest to assign 0 for this user to the new field because
this is also the case for fbsvcmgr action_display_user_adm.
--
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
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
