This question is locked. New answers and comments are not allowed.
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?
1 Answer, 1 is accepted
0
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.
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.