Postgres Pro
Downloads
Home   >   mailing lists

Set the permissions while creating database, schema, and tables - Mailing list pgsql-general

From dipti shah
Subject Set the permissions while creating database, schema, and tables
Date
Msg-id d5b05a951002142335u1554ebfex5db69a45e847c773@mail.gmail.com
Whole thread Raw
Responses Re: Set the permissions while creating database, schema, and tables
List pgsql-general
Tree view
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?


Thanks,
Dipti

pgsql-general by date:

Previous
From: dipti shah
Date:
Subject: Re: The easiest and robust way of configuring password pass through mechanism..
Next
From: John R Pierce
Date:
Subject: Re: Set the permissions while creating database, schema, and tables