Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.20
-
Debian 10
Description
Say you are logged in with your role set to Admin (which is a valid role with most permissions) and you define a view, trigger, stored routine or schedule event with DEFINER = CURRENT_ROLE.
Now do a SQL dump of the database (not the server, just the one database), create a fresh install of Mariadb (so the Admin role does not yet exist), and try to import that dump. It will import successfuly without errors.
Now if you later create a role called Admin (with the same set of privilidges) and try to access the view you will get an error saying that it can't be accessed... i.e. DEFINER = Admin role and I've the the Admin role but I still can't access it.
NOTE that if I drop the database and import it again (now that the users and roles are defined prior to import) everything works correctly as it should.
I'm happy to provide additioal clarification as needed.
can this get assigned?