Re: [GENERAL] Setting permissions to access schema and language

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


[GENERAL] Setting permissions to access schema and language

2010-02-04 Thread Jignesh Shah
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