Re: Setting permissions to access schema and language

From: dipti shah <shahdipti1980(at)gmail(dot)com>
To: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Setting permissions to access schema and language
Date: 2010-02-05 09:24:07
Message-ID: d5b05a951002050124tc80700fp5f2a06e481a78418@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)shah1980(at)gmail(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message aravind chandu 2010-02-05 10:06:12 Query to find list of dates between two dates
Previous Message Grzegorz Jaśkiewicz 2010-02-05 09:21:50 Re: How to escape apostrophes when apostrophes already used to escape something else