Re: [GENERAL] Cannot delete role because it depends on "default privileges"

Wow... I found it. The postgres database contained more default privs. But PGAdmin III nothing say about dependents in it's reports. Thanks! 2016-10-21 16:19 GMT+02:00 Durumdara : > Dear Tom! > > Is there any tool what can show me the dependents or

Re: [GENERAL] Cannot delete role because it depends on "default privileges"

Dear Tom! Is there any tool what can show me the dependents or dependencies? In PGAdmin I don't see any dependencies or dependents... :-( Thanks dd 2016-10-21 16:08 GMT+02:00 Tom Lane : > Durumdara writes: > > The DB_X dropped, so I can't choose it

Re: [GENERAL] Cannot delete role because it depends on "default privileges"

Durumdara writes: > The DB_X dropped, so I can't choose it as "actual database". > I tried this in a neutral database: > drop owned by role_x; > But nothing happened, the error is same. The error you are reporting is describing default privileges that exist in the

Re: [GENERAL] Cannot delete role because it depends on "default privileges"

Dear Tom! The DB_X dropped, so I can't choose it as "actual database". I tried this in a neutral database: drop owned by role_x; But nothing happened, the error is same. As I read it have "CASCADE" mode, but I'm afraid to start it, because I don't know what will happen. It is a really

Re: [GENERAL] Cannot delete role because it depends on "default privileges"

Durumdara writes: > We have a ROLE_MAIN. > This gave default privileges to all next objects in DB_X to ROLE_X. > Somebody dropped DB_X, and later he tried to drop ROLE_X. > But he got errors in PGAdmin. > ERROR: role "role_x" cannot be dropped because some objects depend on

[GENERAL] Cannot delete role because it depends on "default privileges"

Hello! We created a DB named DB_X, and a role ROLE_X. We have a ROLE_MAIN. This gave default privileges to all next objects in DB_X to ROLE_X. Somebody dropped DB_X, and later he tried to drop ROLE_X. But he got errors in PGAdmin. --- pgAdmin III