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
