0

I've granted SELECT privileges for a user to select on all tables of a database. However that user is unsable to view store procedures. I'd want to grant only the permission for SHOW CREATE PROCEDURE (or something alike). Is that possible on MariaDB 10.x?

Improve this question

1 Answer 1

Reset to default
1

Per the knowledge base, SELECT privileges on mysql.proc is sufficient.

Improve this answer
1
  • 1
    This would mean the user is able to see all Procedures on the MariaDB-Server. Its not limited to a database.
    – benjamin
    Commented Jul 4, 2022 at 18:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.