MySQL Forums
Forum List  »  Stored Procedures

Minimum requered permision to execute MySql stored procedures from C# app
Posted by: Andraes Zarvos
Date: August 31, 2018 04:30AM

I have a schema in MySQL '_people' which includes 1 table with two columns (person, telephone number). For simplicity lets assume that i have 4 store procedures.

SP_Find user: Return the persons telephone number (Select)
SP_Add user: Add a new person and telephone number (Insert)
SP_Delete user: Remove person (Delete) - delete row
SP_Update user: Change the person telephone (Update)

Other than the root, I have one user in MySQL. In order for the C# connection to work i need to give to the user:
1) under the Administration Tab - Global Privileges - SELECT
2) under the Schema Privileges - EXECUTE in '_people'.

When i try to remove the first one, the C# request to run any procedure is denied. I don't want to give 'Global Privileges - SELECT' to the c# app because it will have access to Select through all schemas.

I would like to give access to my C# app only to run the '_people' stored procedures. How can i do this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Minimum requered permision to execute MySql stored procedures from C# app
177
August 31, 2018 04:30AM


Sorry, only registered users may post in this forum.

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.