Thread: Set the permissions while creating database, schema, and tables
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 for schema or table. Please let me know if I missed out something.
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 for schema or table. Please let me know if I missed out something.
CREATE DATABASE sales OWNER salesapp TABLESPACE salesspace;
With above command, can I grant permission to particular group of users?
Thanks,
Dipti
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 > couldn't see such option for schema or table. Please let me know if I > missed out something. > > > CREATE DATABASE sales OWNER salesapp TABLESPACE salesspace; > > > With above command, can I grant permission to particular group of users? you would use the GRANT command to grant permissions
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 <pierce@hogranch.com> wrote:
you would use the GRANT command to grant permissionsdipti 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 couldn't see such option for schema or table. Please let me know if I missed out something.
CREATE DATABASE sales OWNER salesapp TABLESPACE salesspace;
With above command, can I grant permission to particular group of users?
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 http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support