In PostgreSQL Database, I need to give only permission to the role for SELECT, INSERT, UPDATE and DELETE. I dont want to give the permission to alter the table such as change column values from NOT NULL to NULL.
How can I restrict this DDL access in PostgreSQL user.
Also I need to remove permission to delete the schema user from the PostgreSQL role.
Kindly suggest if you know.