Postgres Pro
Downloads
Home   >   mailing lists

Re: Remove default privilege from DB - Mailing list pgsql-general

From Durumdara
Subject Re: Remove default privilege from DB
Date
Msg-id CAEcMXhm4=GhR4fe6UDn5jq+mWikJnmAqiztfAwM6i-z5Z3hCLQ@mail.gmail.com
Whole thread Raw
In response to Re: Remove default privilege from DB  (Durumdara <durumdara@gmail.com>)
Responses Re: Remove default privilege from DB
List pgsql-general
Tree view
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 I tried a reverse statement:
ALTER DEFAULT PRIVILEGES FOR ROLE suser grant ALL ON TABLES  to suser;

And then one row eliminated.
4594262;0;"S";"{}"
4594262;0;"T";"{}"
4594262;0;"f";"{}"

Then:
ALTER DEFAULT PRIVILEGES FOR ROLE suser grant ALL ON sequences  to suser;
4594262;0;"T";"{}"
4594262;0;"f";"{}"

Now I need to find a way to eliminate two last lines somehow. 

But it's interesting: the revoking role is makes Black Hole (Sun - poor Soundgarden...)

dd

pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: RE: Dynamic PL/pgSQL select query: value association propblem
Next
From: Pavel Stehule
Date:
Subject: Re: strange construct with RETURN within plpgsql