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.postgres...@gmail.com> 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 > >
