Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.32
-
None
-
Arch Linux
Description
I created 3 roles:
create role vdo_dev, vdo_admin;
I have my own user, called andries, as well as schema called vdo_workflow
I granted access to all elements within the vdo_workflow schema to vdo_dev:
grant ALL on vdo_workflow.* to vdo_dev;
flush privileges;
show grants for vdo_dev and user andries emits the following results:
+--------------------------------------------------------------------------------------------------------+
|
| Grants for andries@% |
|
+--------------------------------------------------------------------------------------------------------+
|
| GRANT vdo_dev TO 'andries'@'%' |
|
+-------------------------------------------------------+
|
| Grants for vdo_dev |
|
+-------------------------------------------------------+
|
| GRANT USAGE ON *.* TO 'vdo_dev' |
|
| GRANT ALL PRIVILEGES ON `vdo_workflow`.* TO 'vdo_dev' |
|
+-------------------------------------------------------+
|
|
When I logged in as andries, and inspect the role I still get null:
MariaDB [(none)]> select current_role;
|
+--------------+
|
| current_role |
|
+--------------+
|
| NULL |
|
+--------------+
|
1 row in set (0.00 sec)
|
 |
MariaDB [(none)]> select current_user;
|
+--------------+
|
| current_user |
|
+--------------+
|
| andries@% |
|
+--------------+
|
1 row in set (0.00 sec)
|
Attachments
Issue Links
- blocks
-
-
- Closed
-