Improve consistency in GRANT syntax between roles and privileges
----------------------------------------------------------------
Key: CORE-5248
URL: http://tracker.firebirdsql.org/browse/CORE-5248
Project: Firebird Core
Issue Type: Improvement
Components: Engine, Security
Reporter: Mark Rotteveel
Priority: Minor
The current syntax of GRANT is inconsistent between privileges and roles.
Specifically, for privileges there is the `WITH GRANT OPTION`, while for roles
there is the `WITH ADMIN OPTION` which has a similar effect (looking at the
langref).
I would propose that for roles the `WITH GRANT OPTION` is also added. The `WITH
GRANT OPTION` means that the user can 1) grant this role to users and 2) revoke
from users the role granted by this user, while `WITH ADMIN OPTION` means that
1) the user can grant privileges to this role and 2) grant this role to users
and 3) revoke this role from all users irrespective of the grantee.
--
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
