>> I (and Hoshiai-san) concern about following case: >> >> # revoke usage on schema s1 from foo; >> REVOKE >> : >> [connect as foo] >> test=> select to_regclass('s1.t1')::oid; >> ERROR: permission denied for schema s1 > > That works in a transaction. It looks right that the actually > revoked schema cannot be accessed. > > S1:foo: begin; > S2:su : revoke usage on schema s1 from foo; > S1:foo: select to_regclass('s1.t1')::oid; >> to_regclass >> ------------- >> 16418 > S2:foo: commit; > S2:foo: select to_regclass('s1.t1')::oid; >> ERROR: permission denied for schema s1
I'm confused. How is an explicit transaction related to the topic? Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp