Re: Remove default privilege from DB

I made a restore to my local Windows PG.

Here I also see these anomalies.

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.

ALTER DEFAULT PRIVILEGES FOR ROLE suser grant ALL ON sequences  to suser;

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