Postgres Pro
Downloads
Home   >   mailing lists

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

From dipti shah
Subject Re: Set the permissions while creating database, schema, and tables
Date
Msg-id d5b05a951002150049h678dac55i378787333e77489f@mail.gmail.com
Whole thread Raw
In response to Re: Set the permissions while creating database, schema, and tables  (John R Pierce <pierce@hogranch.com>)
Responses Re: Set the permissions while creating database, schema, and tables  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view
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:
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



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Set the permissions while creating database, schema, and tables
Next
From: Merlin Moncure
Date:
Subject: Re: how to create a new composite type using already existing composite types