Removing access

Creating PostgreSQL Databases

Darryl Reeves

Assistant Professor, Long Island University - Brooklyn

Example: rolling back privileges

  • Cousin interested in databases
  • Superuser access mistakenly provided
  • Good backup strategy saves the day
  • New user account added
CREATE USER cousin;

ALTER GROUP family ADD USER cousin;

GRANT ALL PRIVILEGES ON finances.* TO cousin;

finances data deleted again

Creating PostgreSQL Databases

Example: rolling back privileges

  • Privileges removed using REVOKE command
  • REVOKE follows similar format to GRANT
REVOKE DELETE, TRUNCATE ON finances.* FROM cousin;
Creating PostgreSQL Databases

Example: rolling back privileges

  • Privileges can be reset
REVOKE ALL PRIVILEGES ON finances.* FROM cousin;

GRANT SELECT ON finances.* FROM cousin;
  • REVOKE can remove users from groups
REVOKE family FROM cousin;
Creating PostgreSQL Databases

Let's practice!

Creating PostgreSQL Databases

Preparing Video For Download...