Re: [HACKERS] Here it is - view permissions - Mailing list pgsql-hackers

On Fri, 20 Feb 1998, Jan Wieck wrote:

> First step done,
>
>     below  is  the patch to have views to override the permission
>     checks for the accessed tables. Now we can do the following:
>
>     CREATE VIEW db_user AS SELECT
>          usename,
>          usesysid,
>          usecreatedb,
>          usetrace,
>          usecatupd,
>          '**********'::text as passwd,
>          valuntil
>         FROM pg_user;

    I used the rewrite RULE here, instead of the above VIEW, with the
VIEW being merely a 'SELECT * FROM pg_user'...by using the RULE (unless
I'm mistaken?), if we change pg_user (ie. add another field at some later
date), the view itself shouldn't require a change...