Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting permissions to access schema and language - Mailing list pgsql-general

From dipti shah
Subject Re: Setting permissions to access schema and language
Date
Msg-id d5b05a951002050124tc80700fp5f2a06e481a78418@mail.gmail.com
Whole thread Raw
In response to Setting permissions to access schema and language  (Jignesh Shah <jignesh.shah1980@gmail.com>)
List pgsql-general
Tree view
This can be done using "GRANT...ON..SCHEMA...". See http://www.postgresql.org/docs/8.4/interactive/sql-grant.html
 
Cheers.

On Thu, Feb 4, 2010 at 4:00 PM, Jignesh Shah <jignesh.shah1980@gmail.com> wrote:
Hi,

I know how to set the permissions for tables. Could anyone tell me how to restrict people accessing and creating schemas? Also, is it possible to restrict language permissions? Suppose I want only few users should use C language and for rest of users it should be missing. How can I restrict permissions on languages?

Thanks in advanced,
Jignesh

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: How to escape apostrophes when apostrophes already used to escape something else
Next
From: Arnaud Lesauvage
Date:
Subject: Valid lc-collate names on Windows