Dear pgsql-general,
I found something strange with DROP TABLE CASCADE.
create role a login;
grant all on database mydb to a;
create role b inherit role a login;
grant all on database mydb to b;
(session of role a)
psql -U a -d mydb;
create schema a;
create table a(i1 int);
(session of role b)
psql -U b -d mydb;
create schema b;
create table b(c1 char);
(session of role a)
create table c() inherits(a.a, b.b);
(session of role b)
drop table a.c;
-->> ERROR: permission denied for schema a
drop table b cascade
NOTICE: drop cascades to table a.c
DROP TABLE
Is it normal?
role b is not owner of table c but role b can drop it with cascade.
If I 'grant all on schema a to b', role b still cannot drop table c. Because role b is not owner of table c.
Sorry for poor English.
Thanks.
