• Marc G. Fournier's avatar
    First step done, · 7b30490b
    Marc G. Fournier authored
        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;
    7b30490b
execMain.c 34.3 KB