액세스 제거

PostgreSQL 데이터베이스 만들기

Darryl Reeves

Assistant Professor, Long Island University - Brooklyn

예시: 권한 되돌리기

CREATE USER cousin;

ALTER GROUP family ADD USER cousin;

GRANT ALL PRIVILEGES ON finances.* TO cousin;

finances 데이터가 다시 삭제됨

REVOKE DELETE, TRUNCATE ON finances.* FROM cousin;

REVOKE ALL PRIVILEGES ON finances.* FROM cousin;

GRANT SELECT ON finances.* FROM cousin;

REVOKE family FROM cousin;

PostgreSQL 데이터베이스 만들기