Received: from sisyphus.owlscreech.com (owlscreech.com [207.174.31.35]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eALKJgs21866 for ; Tue, 21 Nov 2000 15:19:42 -0500 (EST) (envelope-from brian@owlscreech.com) Received: from [192.168.0.2] ([63.229.251.51]) by sisyphus.owlscreech.com (8.9.3/8.8.7) with ESMTP id NAA09599 for ; Tue, 21 Nov 2000 13:17:27 -0700 User-Agent: Microsoft-Entourage/9.0.2509 Date: Tue, 21 Nov 2000 13:17:17 -0700 Subject: Permissions Broken in 7.0.x? From: Brian Powell To: Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200011/177 X-Sequence-Number: 208 Greetings, I am having problem with table permissions and view permissions. Say I am user bob and I own a database, bobdb. Let us also assume a user, tester has been added to the db, via create user... % psql bobdb psql => create table test ( name char(32) not null, age int4 ); psql => revoke all on test from tester; CHANGE psql => select * from test; ERROR: test: Permission denied. Why would this be so? I only revoked the user tester. So, I add myself: Additionally, if I have a trigger on a table which sets the updated_date and updated_by on any update, and I have a view with a rule which passes any update to the table (thus calling the trigger), I get a permission denied. I am supposing that the user updating the view does not have privileges to the trigger? How would I grant them privileges to the trigger? Thank you for your assistance. --Brian