Re: Remove default privilege from DB

[Durumdara <durumdara@xxxxxxxxx>]

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