pgsql: Relax permissions checks on dbsize functions, per discussion.

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Relax permissions checks on dbsize functions, per discussion.
Date: 2007-08-29 17:24:29
Message-ID: 20070829172429.A7971754201@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Relax permissions checks on dbsize functions, per discussion. Revert out all
checks for individual-table-size functions, since anyone in the database could
get approximate values from pg_class.relpages anyway. Allow database-size to
users with CONNECT privilege for the target database (note that this is
granted by default). Allow tablespace-size if the user has CREATE privilege
on the tablespace (which is *not* granted by default), or if the tablespace is
the default tablespace for the current database (since we treat that as
implicitly allowing use of the tablespace).

Modified Files:
--------------
pgsql/src/backend/utils/adt:
dbsize.c (r1.13 -> r1.14)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/dbsize.c?r1=1.13&r2=1.14)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2007-08-29 20:37:15 pgsql: Move full text search operators, functions, and data type
Previous Message Tom Lane 2007-08-29 16:32:11 pgsql: Fix aboriginal bug in _tarAddFile(): when complaining that the