Can we set a DEFINER as a ROLE when we create a stored procedure? I'd like to limit the access to all tables, except when using a stored procedure. But when the stored procedure includes a SELECT, the executer needs to have the SELECT permissions as well. Any advise?
@iSolver_ES - Yes, absolutely! You would create a ROLE, give the role access to the procedure and then give the user the ROLE. This way the user does not have direct access to the table(s). Cheers!
After a unintentional break, we continue with our exploration of MariaDB. Please Like, Comment and Subscribe! Cheers!
👏👏👏
@Rasha kh - Thank you! Cheers!
Can we set a DEFINER as a ROLE when we create a stored procedure? I'd like to limit the access to all tables, except when using a stored procedure. But when the stored procedure includes a SELECT, the executer needs to have the SELECT permissions as well. Any advise?
@iSolver_ES - Yes, absolutely! You would create a ROLE, give the role access to the procedure and then give the user the ROLE. This way the user does not have direct access to the table(s). Cheers!
I’m considered moving from SQL Server to MariaDB. The Sql syntax looks similar, but any experience/gotchas I should know about? Thanks
Sir what about using xampp sir? 🙏 Hope you'll notice