]> granicus.if.org Git - postgresql/commit
First step done,
authorMarc G. Fournier <scrappy@hub.org>
Sat, 21 Feb 1998 06:32:15 +0000 (06:32 +0000)
committerMarc G. Fournier <scrappy@hub.org>
Sat, 21 Feb 1998 06:32:15 +0000 (06:32 +0000)
commit7b30490bc9cebef913f6f95cd0487a3c6989dafa
treea826fdf123b0782acf3c114f8b4287fd3f774015
parent734328840c636d056d6d0a20bdde2af317d4e110
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;

    REVOKE ALL ON pg_user FROM public;
    REVOKE ALL ON db_user FROM public;
    GRANT SELECT ON db_user TO public;
src/backend/executor/execMain.c
src/backend/nodes/copyfuncs.c
src/backend/parser/gram.c
src/backend/parser/scan.c
src/backend/rewrite/rewriteHandler.c
src/include/nodes/parsenodes.h
src/interfaces/ecpg/Makefile