Hi,
Could anyone please help me out here. I want to set the required permissions
while creating PostGreSQL database, schema, and tables from stored
procedures. Is it possible to do it while creating them?
I could see that OWNER option is there while creating database but
couldn't see such option
dipti shah wrote:
Hi,
Could anyone please help me out here. I want to set the required
permissions while creating PostGreSQL database, schema, and tables
from stored procedures. Is it possible to do it while creating them?
I could see that OWNER option is there while creating database but
That's I know but I was wondering if there is anyway to do it while creating
itself.
On Mon, Feb 15, 2010 at 1:46 PM, John R Pierce pie...@hogranch.com wrote:
dipti shah wrote:
Hi,
Could anyone please help me out here. I want to set the required
permissions while creating PostGreSQL
dipti shah escribió:
That's I know but I was wondering if there is anyway to do it while creating
itself.
No. You can wrap the CREATE and the GRANT/REVOKE into a transaction so
that the object doesn't appear to users until permissions have been
fixed.
--
Alvaro Herrera