Skip site navigation (1) Skip section navigation (2)

newsysviews - newsysview: finally get around to qualifying pg_all_grants

From: andrewsn(at)pgfoundry(dot)org (User Andrewsn)
To: pgsql-committers(at)postgresql(dot)org
Subject: newsysviews - newsysview: finally get around to qualifying pg_all_grants
Date: 2005-05-13 03:41:59
Message-ID: 20050513034159.14A00112500C@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
finally get around to qualifying pg_all_grants correctly. We show a
grant if any of these is true:
  - current_user is a superuser
  - the grantor is current_user
  - the grantee is current_user
  - the owner of the object is current_user
  - the grantee is "public"
  - the grantee is a group of which current_user is a member

Modified Files:
--------------
    newsysview/sql:
        grant.sql (r1.5 -> r1.6)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/grant.sql.diff?r1=1.5&r2=1.6)

pgsql-committers by date

Next:From: User AndrewsnDate: 2005-05-13 03:45:06
Subject: newsysviews - newsysview: always use schema-qualification in function
Previous:From: User AndrewsnDate: 2005-05-13 02:01:57
Subject: newsysviews - newsysview: make build.sh a bit safer for users.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group