| 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: | Whole Thread | Raw Message | 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
>
| 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 |