Tested against PostgreSQL version 11
This is how you drop a user (or "role" as it is called in postgresQL):
--If necessary, transfer object to another user first: reassigned owned by scott TO jim; -- remove privileges granted to scott for objects that it doesn't own: drop owned by scott; -- finally, drop the user: drop user scott;Documentation
No comments:
Post a Comment