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
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 |