I have created a centralized database using PostgreSQL and created multiple users assigned with different roles i.e.
CREATE USER hasan WITH PASSWORD 'hasan'
GRANT SELECT ON pois TO hasan
For user 'hasan' I have granted
SELECT privileges on the
pois table which means he can only select and view the data. It works perfectly both in PostgreSQL and QGIS environment. The user can only run select query on the table and view the data in QGIS environment and cannot update or delete any record as I expected.
But the problem is in the QGIS environment, when the user right click on the table, he can easily export the table into a shapefile and then edit or update whatever he wants to do.
What can I do to stop the user from exporting the PostGIS table to a shapefile in QGIS?