Reputation: 3772
I created a read only user in PostgreSQL using the command line by:
CREATE USER xyz WITH ENCRYPTED PASSWORD 'xxx';
GRANT SELECT ON DATABASE mydb TO xyz;
In order to delete this user, what's the difference between
DROP USER xyz;
and
DROP ROLE xyz;
Upvotes: 0
Views: 328
Reputation: 21356
There is no difference. From the docs:
DROP USER
is simply an alternate spelling ofDROP ROLE
.
Upvotes: 3