| From: | Thomas Boussekey <thomas(dot)boussekey(at)gmail(dot)com> |
|---|---|
| To: | pavan(dot)postgresdba(at)gmail(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Granting a user the privilege to create views? |
| Date: | 2018-08-28 09:46:56 |
| Message-ID: | CALUeYmesEkm1yju_fZgZoLSzZAa_GA4TLqYbwn+61YidSOa9Fw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)postgresdba(at)gmail(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2018-08-28 12:26:56 | Re: Will there ever be support for Row Level Security on Materialized Views? |
| Previous Message | pavan95 | 2018-08-28 09:00:13 | Re: Granting a user the privilege to create views? |