Hi,
Quick question: We have a role that needs to be updated regularly whenever there is a new table in a specific schema. Do the privileges that already exist for that role have to be revoked first and re-granted so to speak or simply add, "GRANT SELECT ON new_table TO role_name;"?