Re: [GENERAL] Set the permissions while creating database, schema, and tables

2010-02-15 Thread Alvaro Herrera
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

Re: [GENERAL] Set the permissions while creating database, schema, and tables

2010-02-15 Thread dipti shah
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 wrote: > dipti shah wrote: > >> Hi, >> >> Could anyone please help me out here. I want to set the required >> permissions while creating PostGreSQL database, schem

Re: [GENERAL] Set the permissions while creating database, schema, and tables

2010-02-15 Thread John R Pierce
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

[GENERAL] Set the permissions while creating database, schema, and tables

2010-02-15 Thread dipti shah
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 optio