Re: Temporary tables privileges

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