What user to defaults execute as?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general(at)postgresql(dot)org
Subject: What user to defaults execute as?
Date: 2002-10-30 14:27:37
Message-ID: 20021030142737.GA4501@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Do default expressions execute with access of the user doing the insert
or the owner of the table?
What I was thinking was that the owner of a table may want to allow people
to do inserts into a table and update a sequence through a default expression,
but not let people change the sequence directly.
A quick look under create table (in the 7.3b3 docs) didn't turn up any
information and I don't remember running accross anything covering this
previously.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johannes Lochmann 2002-10-30 14:35:30 Re: [SQL] Database Design tool
Previous Message Bill Gribble 2002-10-30 14:24:28 Re: Database replication... - Mission Critical DBMS's --

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2002-10-30 15:18:47 Re: Database replication... - Mission Critical DBMS's --
Previous Message Bill Gribble 2002-10-30 14:24:28 Re: Database replication... - Mission Critical DBMS's --