Privacy P-11
No DROP or ALTER
for Your App User.
for Your App User.
Superuser app role
DROP TABLE
ALTER SCHEMA
GRANT ALL
Scoped app role
SELECT, INSERT, UPDATE
on app.* only
LaunchYourVibe P-11
Least privilege on database users. Your app's database user shouldn't have DROP or ALTER permissions. Give it only what it needs to function — SELECT, INSERT, UPDATE, DELETE on specific tables.
