Am 13.12.2018 um 11:09 schrieb Thomas Plant:
Hello all,
I have a request from a user who can not create a view in his database.
He has the following rights granted:
+----------------------------------------------------------------------------------------------------------------+
| Grants for user@%
|
+----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD '***************'
|
| GRANT ALL PRIVILEGES ON `dbname`.* TO 'user'@'%'
|
+----------------------------------------------------------------------------------------------------------------+
The view he tries to create looks like these:
CREATE ALGORITHM=UNDEFINED DEFINER=`xxxxxxxxxxx`@`xx.xxx.xxx.x/xxx.xxx.xxx.x`
SQL SECURITY DEFINER
VIEW `jos_docman_file_counts` AS select
`jos_docman_documents`.`storage_path` AS `storage_path`,count(0) AS `count`
from `jos_docman_documents` where
(`jos_docman_documents`.`storage_type` = 'file')
group by `jos_docman_documents`.`storage_path`;
And gets as error:
#1227 - Access denied; you need (at least one of) the SUPER
privilege(s) for this operation
What SUPER privilege is needed for this view?
The Database is MariaDB 10.1 on Centos 7.
Thanks for any hint about his.
Greetings,
Thomas
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
Found something with Google:
https://stackoverflow.com/questions/13492857/create-view-without-super-privileges-in-phpmyadmin
So I'd say the installation routine of the plugin is using the wrong
user in the DEFINER statement?
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
