Re: [GENERAL] Question on table inheritance and privileges

2016-08-04 Thread Adrian Klaver
On 08/02/2016 09:35 PM, 윤기태 wrote: Dear pgsql-general, I found something strange with DROP TABLE CASCADE. Not really, explanation inline below. 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; The above leads to

[GENERAL] Question on table inheritance and privileges

2016-08-03 Thread 윤기태
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