Re: Adding new sproc to the exisiting database using connectors?

[Ivan Evstegneev]

Peter Brawley Wrote:
-------------------------------------------------------
> usually it's much easier to develop stored
> routines in text/code editors and debug them is
> simple clients like the mysql client program.

Hello again ^_^,

So in case I've got you right, this is not a common practice to add new sprocs via connectors? BTW this is something called encapsulation right?

Instead, I need to create them directly on a server (using mysql shell or mysql workbench) and then just to call them?

The second though: if someone is able to add new sprocs with connector (or even directly) can it be considered as a security breach in my database?

Sincerely,

Ivan.