Anonymous: Represents anonymous or unauthenticated users. Used for public access or actions that don't require login.
Authenticated: Represents users logged into the application. Used for actions requiring a signed-in user.
pgSodium Roles
Encryption Management
pgsodium_keyholder: Manages encryption keys for pgSodium, a PostgreSQL encryption extension.
pgsodium_keyiduser: Identifies and uses specific encryption keys for pgSodium.
pgsodium_keymaker: Creates and manages encryption keys for pgSodium.
Administrative Roles
Elevated Privileges
service_role: High-privilege role for server-side operations, bypassing Row Level Security (RLS). Use cautiously for administrative tasks or background jobs.
References