| From: | Travis Bauer <trbauer(at)indiana(dot)edu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | setting permissions on a new table in a trigger |
| Date: | 2000-05-26 21:23:22 |
| Message-ID: | Pine.GSO.4.21.0005261619270.8719-100000@mantaray.cs.indiana.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a trigger that creates a number of new views and create a user upon
insert into a table. The trigger is writtne in c. Works great.
I also have to revoke all permissions on the new table, grant all to the
group "officestaff" and grant select to the new user. I cannot do this in
the trigger itself because the new tables creations are not yet committed
to the database.
Question: Is there a way to create tables _and_ set permissions on those
tables within a single trigger, or is there some other way to get the
permissions set automatically?
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-05-26 21:45:27 | Re: Speed of locating tables? |
| Previous Message | Alfred Perlstein | 2000-05-26 20:55:02 | Re: Performance issue 6.5 versus 7.0 |