Re: VIEW DEFINTION permission
Posted by:
Devart Team
Date: September 23, 2010 08:17AM
>
I find that even after disconnecting and reconnecting user1 still has rights to view procedure definitions in the test DB.
The definition still can be being seen by 'user1'@'%' if procedure is created with definer 'user1'@'%'.
>
As I showed in my original post the user I want to allow to view procedure definitions has SELECT rights on * in my user-defined DB and yet still cannot view procedure definitions. Are there any other database-level permissions I should look at? Any other ideas?
Try to grant 'SELECT' privilege to `mysql`.`proc` table, then select data from that table.
Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/
Subject
Written By
Posted
September 20, 2010 12:16PM
September 22, 2010 02:04AM
September 22, 2010 06:49AM
September 22, 2010 08:31AM
September 22, 2010 09:47AM
September 23, 2010 01:18AM
September 23, 2010 07:17AM
Re: VIEW DEFINTION permission
September 23, 2010 08:17AM
September 23, 2010 09:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.