[MDEV-15172] SELECT command denied for user when selecting from CTE Created: 2018-02-01  Updated: 2018-04-02  Resolved: 2018-04-02

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: 10.2.9
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Darias G Brown Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: cte, need_feedback, permissions
Environment:

Red Hat Enterprise Linux Server 7.4


 Description   

Executing the following simple CTE query:

with d as
(select associated_id from ROLE_ASSOC where parent_id='111111111-0744-11e8-96d3-f405541eda2e')
select * from d;

gives the following error:

SQL Error (1142): SELECT command denied user '<user_name>' for table 'd'

Per MDEV-13453 the fix for this bug was pushed into the 10.2 tree, however I am still seeing the issue in 10.2.9.

 Comments   
Comment by Darias G Brown [ 2018-02-01 ]

ROLE_ASSOC is a view and the user has SELECT permissions on the view.

Comment by Elena Stepanova [ 2018-02-01 ]

As MDEV-13453 says, it was fixed in 10.2.11. It's not surprising you have the problem in 10.2.9, you need to upgrade.

Comment by Elena Stepanova [ 2018-03-03 ]

dariasbrown, has upgrade helped?

Generated at Thu Feb 08 08:19:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.