| 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: | Whole Thread | Raw Message | 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.
| 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 -- |
| 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 -- |