Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5164

Testing Roles

        Details

        • Type: Task
        • Status: Stalled
        • Priority: Major
        • Resolution: Unresolved
        • Fix Version/s: 10.1, 10.0
        • Component/s: None
        • Labels:
          None

          Description

          Main development task (10.0):

          MDEV-4397 Roles

          10.1 additions:

          MDEV-6918 Create a way to see a user's default role
          MDEV-7288 USER/ROLE: CREATE OR REPLACE, CREATE IF NOT EXISTS, DROP IF EXISTS
          MDEV-5214 Status variables for number of global/db/table/column/role grants
          MDEV-5210 Default role

          r1

            Gliffy Diagrams

              Attachments

                Issue Links

                is blocked by

                Task - A task that needs to be done. MDEV-4397 Roles

                • Major - Major loss of function.
                • Closed
                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8627 SHOW GRANTS does not work for a replicated role (throws 'There is no such grant defined for user ...')

                • Major - Major loss of function.
                • Open

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8638 REVOKE ALL PRIVILEGES, GRANT OPTION FROM CURRENT_ROLE breaks replication

                • Major - Major loss of function.
                • Open

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8616 Inconsistent behavior of GRANT/REVOKE PROXY with roles

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Open

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5228 Incorrect message test on a failed attempt to revoke grants from a role

                • Trivial - Cosmetic problem like misspelt words or misaligned text.
                • Open

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8609 Server crashes in is_invalid_role_name on reloading ACL with a blank role name

                • Major - Major loss of function.
                • Confirmed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8614 Assertion `status == 0' failed in add_role_user_mapping_action on RENAME USER

                • Major - Major loss of function.
                • Confirmed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8612 Assertion `granted_role->is_role()' failed in mysql_grant_role on granting role starting with 0-character

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Confirmed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5772 Granting multiple roles in single statement does not work

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Stalled

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5166 10.0-roles does not build with BUILD/compile-pentium-debug-max-no-ndb

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5170 Assertion `(&(&acl_cache->lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&acl_cache->lock)->m_mutex)->thread)' fails after restarting server with a pre-created role grants

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5172 safe_mutex: Trying to lock mutex when the mutex was already locked on using a role and I_S role tables

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5175 Revoking a role does not revoke corresponding grants from open sessions

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5221 User auto-creation does not work upon GRANT <role>

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5223 Server crashes on REVOKE ... from CURRENT_ROLE

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5225 Server crashes on CREATE USER|ROLE CURRENT_ROLE or DROP ROLE CURRENT_ROLE

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5238 Server crashes in find_role_grant_pair on SHOW GRANTS for an anonymous user

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5668 Assertion `granted_role->is_role()' fails on granting role with empty name

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5669 Possible inconsistencies or lack of documentation in role privilege grants and propogation

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5771 Privileges acquired via roles depend on the order of granting

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5237 Minor inconsistency between current_role and I_S.enabled_roles

                • Trivial - Cosmetic problem like misspelt words or misaligned text.
                • Closed

                Task - A task that needs to be done. MDEV-5227 Resolve the ambiguity between user and role names as mentioned in MDEV-4397

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Open

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8176 Overuse/misuse of ERROR 1959 (OP000): Invalid role specification

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Open

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8174 Assertion `status == 0' failed in add_role_user_mapping_action

                • Major - Major loss of function.
                • Closed

                  Activity

                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment - - edited

                  ~elenst/+junk/mariadb-toolbox/grammars/users_and_roles.yy
                  ~elenst/+junk/mariadb-toolbox/grammars/10.1-users_and_roles.yy
                  Requires changes in RQG to have system (root) dsns and the "normal" user dsns.

                  Show
                  elenst Elena Stepanova added a comment - - edited ~elenst/+junk/mariadb-toolbox/grammars/users_and_roles.yy ~elenst/+junk/mariadb-toolbox/grammars/10.1-users_and_roles.yy Requires changes in RQG to have system (root) dsns and the "normal" user dsns.

                    People

                    • Assignee:
                      elenst Elena Stepanova
                      Reporter:
                      serg Sergei Golubchik
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 2 days, 2 hours
                        2d 2h