| From: | dipti shah <shahdipti1980(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | has_schema_privilege function |
| Date: | 2010-03-09 08:53:03 |
| Message-ID: | d5b05a951003090053r13df0187u54273e631cb778fc@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
Hi,
I refered
http://www.postgresql.org/docs/8.4/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE
and
got to know that I can fetch the information about permissions on schema.
Below commands work fine:
SELECT has_schema_privilege('user1', 'mydb', 'USAGE');
SELECT has_schema_privilege('user1', 'mydb', 'CREATE');
...But I want to check whether user has ALL permissions or not. Below
doesn;t work.
SELECT has_schema_privilege('user1', 'mydb', 'ALL');
Do I have to check both USAGE and CREATE permissions to check ALL
permissions?
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodger Donaldson | 2010-03-09 09:01:52 | Re: kernel version impact on PostgreSQL performance |
| Previous Message | Ian Barwick | 2010-03-09 08:50:45 | Unexpected result from selecting an aliased but non-existing column called "name" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasen Betts | 2010-03-09 10:15:16 | Re: Entering a character code in a query |
| Previous Message | Greg Smith | 2010-03-09 07:15:32 | Re: [NOVICE] How to read oracle table's data from postgre |