Proc Permission execute procedure

Thread is closed for posting
2 posts, 0 answers
  1. Benny
    Benny avatar
    33 posts
    Member since:
    May 2009

    Posted 16 Mar 2010 Link to this post

    Hi,
    I get the following exception (on a MySQL database):
    Telerik.OpenAccess.RT.sql.SQLException: SELECT command denied to user 'abc'@'12.34.56.78' for table 'proc'
    When executing:
    IQuery q1 = _scope.GetSqlQuery("sp_mySP", null, null);
    q1.Execute();

    Is there any way to execute a stored procedure without permission to the table proc?

  2. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 17 Mar 2010 Link to this post

    Hello Benny,

    I am afraid this is not possible because each command that the stored procedure executes is executed with the rights your user has. Having this in mind, if you cannot read particular table, you cannot do so via stored procedure as well. Hope that helps.

    Best wishes,
    Damyan Bogoev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Back to Top