Kevin Grittner wrote:
> >>> raf wrote:
> > revoke all privileges on schema public from public;
> > revoke all privileges on schema public from staff; -- staff is a role
> >
> > then i get two warnings:
> >
> > WARNING: no privileges could be revoked for "public"
> > WARNING: no privi
>>> raf wrote:
> revoke all privileges on schema public from public;
> revoke all privileges on schema public from staff; -- staff is a
role
>
> then i get two warnings:
>
> WARNING: no privileges could be revoked for "public"
> WARNING: no privileges could be revoked for "public"
>
Milen A. Radev wrote:
> raf :
> > hi,
> >
> > in my database, normal users can't select, insert, update or
> > delete anything directly. they can only call functions which
> > are all security defining functions which give access to the
> > data. that's the way i like it.
> >
> > how
raf написа:
> hi,
>
> in my database, normal users can't select, insert, update or
> delete anything directly. they can only call functions which
> are all security defining functions which give access to the
> data. that's the way i like it.
>
> however, i discovered that normal users can create
