pgsql: Relax permissions checks on dbsize functions, per discussion. - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Relax permissions checks on dbsize functions, per discussion.
Date
Msg-id 20070829172429.A7971754201@cvs.postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix aboriginal bug in _tarAddFile(): when complaining that the
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Move full text search operators, functions, and data type