Hello Olivier,
You can write an event trigger that will prevent specific user to create objects that are not views.
Link to the CREATE EVENT TRIGGER documentation: https://www.postgresql.org/docs/current/static/sql-createeventtrigger.html
Regards,
Thomas
Le mar. 28 août 2018 à 11:00, pavan95 <pavan.postgresdba@xxxxxxxxx> a écrit :
Hi Olivier,
Instead if you grant select privilege on a table to a particular user, he
can be able to create whatever the views he wants to.
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
