[MDEV-7621] Grant execute on all users does not work as the manual says Created: 2015-02-23  Updated: 2015-02-25  Resolved: 2015-02-25

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.1.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Philip orleans Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

fedora 20


 Description   

I have a stored procedure that I want all my users to be able to execute, without having to assign the privilege individually, since they are hundreds.
So I found in the manual this statement
GRANT EXECUTE ON PROCEDURE MariaDBProc TO '*'@'localhost';
http://www.techonthenet.com/mariadb/grant_revoke.php
In old mysql, they say to use
GRANT EXECUTE ON PROCEDURE MariaDBProc TO ''@'localhost';
I actually use
GRANT EXECUTE ON PROCEDURE MariaDBProc TO '*'@'%';
or
GRANT EXECUTE ON PROCEDURE MariaDBProc TO ''@'';
but neither statement makes my users to execute the stored procedure.

 Comments   
Comment by Elena Stepanova [ 2015-02-25 ]

Hi,

MariaDB has never supported this syntax (and neither has MySQL). It's a 3rd-party manual, it's wrong.

For the variant ''@'localhost', it is supported but it has somewhat different semantics. It's not a wildcard for any user; it's an anonymous user. Users which have actual named accounts in your system won't match it.

Comment by Philip orleans [ 2015-02-25 ]

Can you point to the manual where I can see described how to gran execute
rights to anonymous users?
Federico

On Wed, Feb 25, 2015 at 9:32 AM, Elena Stepanova (JIRA) <

Comment by Elena Stepanova [ 2015-02-25 ]

http://dev.mysql.com/doc/refman/5.5/en/grant.html
Search for 'anonymous'.

Generated at Thu Feb 08 07:21:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.