Membuat Database 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;
Data finances terhapus lagi
REVOKEREVOKE mirip GRANTREVOKE DELETE, TRUNCATE ON finances.* FROM cousin;
REVOKE ALL PRIVILEGES ON finances.* FROM cousin;
GRANT SELECT ON finances.* FROM cousin;
REVOKE dapat menghapus pengguna dari grupREVOKE family FROM cousin;
Membuat Database PostgreSQL