Thanks Bruce, then how can I grant an user to create tmp tables and
drop then it, without gives him global drop priv (I can't grant drop
priv for the tmp table because don't exist yet)
Thnx, Alejandro
Sorry 4 my english
On Fri, 11 Mar 2005 10:52:05 -0500 (EST), Bruce Momjian
Alejandro D. Burne wrote:
Thanks Bruce, then how can I grant an user to create tmp tables and
drop then it, without gives him global drop priv (I can't grant drop
priv for the tmp table because don't exist yet)
Perhaps you need a SECURITY DEFINER function. You can set the
permissions on the
Alejandro D. Burne wrote:
Hi, I'm new at pg.
I'll be using tmp tables in others rdbms. An user can create your own
tmp tables (grant temporary tables) but can't drop it (I don't want to
grant drop privileges).
Other way it's using on commit; but I can't make this work.
Example:
CREATE
Hi, I'm new at pg.
I'll be using tmp tables in others rdbms. An user can create your own
tmp tables (grant temporary tables) but can't drop it (I don't want to
grant drop privileges).
Other way it's using on commit; but I can't make this work.
Example:
CREATE TEMPORARY TABLE tmp ON COMMIT DROP