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?
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.