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 temp schemas too:
GRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE dbname [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH
GRANT OPTION ]
I have forgotten what you are trying to do.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073