Permissions Broken in 7.0.x?

From: Brian Powell <brian(at)owlscreech(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Permissions Broken in 7.0.x?
Date: 2000-11-21 20:17:17
Message-ID: B640265D.1448%brian@owlscreech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-11-21 21:14:18 Re: Permissions Broken in 7.0.x?
Previous Message Ricardo Dias Marques 2000-11-21 18:56:36 CREATE OR REPLACE VIEW