How to Simplify Permission Management with MariaDB Roles

This article explains why database roles are essential for efficient permission handling, outlines the benefits of using roles, and provides step‑by‑step instructions with screenshots for creating and assigning roles in MariaDB, while noting MySQL's current lack of support.

Database RolesMariaDBSQL

0 likes · 3 min read

How to Simplify Permission Management with MariaDB Roles

dbaplus Community

Oct 22, 2015 · Databases

Understanding PostgreSQL Function Security: Definer vs Invoker Explained

This article explains how PostgreSQL functions can be defined with security definer or security invoker, details the differences between session_user and current_user, demonstrates setting roles and search_path, and provides practical examples and safeguards to prevent privilege escalation.

Database RolesFunction SecurityPostgreSQL

0 likes · 5 min read

Understanding PostgreSQL Function Security: Definer vs Invoker Explained