Add virtual table SEC$ROLES to return all roles currently active for the
connected user
---------------------------------------------------------------------------------------
Key: CORE-5239
URL: http://tracker.firebirdsql.org/browse/CORE-5239
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Dmitry Yemanov
After introducing default (and aggregated) roles, CURRENT_ROLE becomes
practically useless in such cases. We now have RDB$ROLE_IN_USE(<role name>) to
check for a particular role, this replaces the IF (CURRENT_ROLE = <role name>)
functionality for the cases with multiple active roles. But it would be also
handy to just know (enumerate) all the active roles, hence this ticket.
SEC$ROLES may either return all roles active for the current user, or return
all roles granted to the current user with a flag whether every role is
currently active or not.
--
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
------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
