On Fri, Feb 16, 2018 at 8:59 AM, Stephen Frost wrote:
> Tom,
>
> * Tom Lane (t...@sss.pgh.pa.us) wrote:
> > Stephen Frost writes:
> > > * David G. Johnston (david.g.johns...@gmail.com) wrote:
> > >> Not sure if this is what you mean but there is no concept of
> "negative
> > >> state" in the pe
Tom,
* Tom Lane (t...@sss.pgh.pa.us) wrote:
> Stephen Frost writes:
> > * David G. Johnston (david.g.johns...@gmail.com) wrote:
> >> Not sure if this is what you mean but there is no concept of "negative
> >> state" in the permissions system. Everything starts out with no
> >> permissions. Gra
Stephen Frost writes:
> * David G. Johnston (david.g.johns...@gmail.com) wrote:
>> Not sure if this is what you mean but there is no concept of "negative
>> state" in the permissions system. Everything starts out with no
>> permissions. Grant adds permissions and revoke un-adds granted
>> permi
Greetings,
* David G. Johnston (david.g.johns...@gmail.com) wrote:
> On Fri, Feb 16, 2018 at 7:56 AM, Durumdara wrote:
>
> > I want to know what happened in the background.
> > I will make "negative" state if I revoke DefACL without prior grant?
>
> Not really following the whole thread but fi
On Fri, Feb 16, 2018 at 7:56 AM, Durumdara wrote:
> I want to know what happened in the background.
> I will make "negative" state if I revoke DefACL without prior grant?
>
Not really following the whole thread but figured I'm comment on this
point that confused me in the past as well.
Not s
Dear Charles!
I did search on backup SQL, and I found 4 lines. All of them needed. I
reversed them (Revoke to Grant):
ALTER DEFAULT PRIVILEGES FOR ROLE suser grant ALL ON TYPES to PUBLIC;
ALTER DEFAULT PRIVILEGES FOR ROLE suser grant ALL ON TYPES to suser;
ALTER DEFAULT PRIVILEGES FOR ROLE sus
Dear Charles - Prof. Xavier? :-)
I made a restore to my local Windows PG.
Here I also see these anomalies.
4594262;0;"S";"{}"
4594262;0;"T";"{}"
4594262;0;"f";"{}"
4594262;0;"r";"{}"
In restore SQL I saw:
ALTER DEFAULT PRIVILEGES FOR ROLE suser REVOKE ALL ON TABLES FROM suser;
Because of that
Hello!
2018-02-15 14:19 GMT+01:00 Charles Clavadetscher :
> What version of PostgreSQL are you using?
>
> And how did you get those first entries at all?
>
> What happens if you issue
>
> ALTER DEFAULT PRIVILEGES FOR ROLE suser GRANT EXECUTE ON FUNCTIONS TO
> PUBLIC;
>
> again?
>
>
> After that:
Hi
From: Durumdara [mailto:durumd...@gmail.com]
Sent: Donnerstag, 15. Februar 2018 12:41
To: Charles Clavadetscher
Cc: Postgres General
Subject: Re: Remove default privilege from DB
Dear Charles!
2018-02-12 10:03 GMT+01:00 Charles Clavadetscher mailto:clavadetsc...@swisspug.org
Dear Charles!
2018-02-12 10:03 GMT+01:00 Charles Clavadetscher :
> Hi
>
>
>
> *From:* Durumdara [mailto:durumd...@gmail.com]
> *Sent:* Montag, 12. Februar 2018 09:32
> *To:* Postgres General
> *Subject:* Remove default privilege from DB
>
>
>
> Hello!
>
&g
Hi
From: Durumdara [mailto:durumd...@gmail.com]
Sent: Montag, 12. Februar 2018 09:32
To: Postgres General
Subject: Remove default privilege from DB
Hello!
I need to remove default privileges from a Database.
After that some of them remains.
Default access privileges
Hello!
I need to remove default privileges from a Database.
After that some of them remains.
Default access privileges
Owner| Schema | Type | Access privileges
++--+---
postgres || function | =X/postgres
postgres |
12 matches
Mail list logo
