Home > mailing lists

has_schema_privilege function - Mailing list pgsql-novice

From	dipti shah
Subject	has_schema_privilege function
Date	March 9, 2010 07:53:15
Msg-id	d5b05a951003090053r13df0187u54273e631cb778fc@mail.gmail.com Whole thread Raw
List	pgsql-novice

Hi,

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: dipti shah
Date: 09 March 2010, 05:27:09
Subject: How to save existing permissions on schema and later on restore it?

From: Jasen Betts
Date: 09 March 2010, 09:15:37
Subject: Re: Entering a character code in a query