MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

User is unable to view stored procedure. root can view it.
Posted by: uzair qadir
Date: September 18, 2012 02:25AM

Hello,

A normal user is unable to view stored procedure. It was able to view and alter it untill yesteday i don't know what happened today. When the user try to view stored procedure body following error comes.

DROP PROCEDURE IF EXISTS Nucleus.CDRFileconfigurationByConfigurationId_Get;
-- Unable to find procedure body;

whereas if i login from root user. everything works fine. i have checked the previlllages or user all options are checked for that database against that user. This is happening to all user which have seperate rights on seperate databases.

Mysql version is 5.1

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
User is unable to view stored procedure. root can view it.
9458
uzair qadir
September 18, 2012 02:25AM
Solution: User is unable to view stored procedure. root can view it.
3633
uzair qadir
September 18, 2012 02:47AM


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.