Re: Granting all tables in schema by one SQL command - Mailing list pgsql-hackers

Hello

Im new to PostgreSQL development and I would like to make "introduce"
patch that will satisfied this point of TODO:
"%Allow GRANT/REVOKE permissions to be applied to all schema objects with
one command

The proposed syntax is:

GRANT SELECT ON ALL TABLES IN public TO phpuser; GRANT SELECT ON NEW
TABLES IN public TO phpuser;"

My proposal of SQL syntax is:

GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON ALL TABLES IN schema_name[,...]
TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ]

for granting all tables/views in schema

and

REVOKE [ GRANT OPTION FOR ]
{ { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON ALL TABLES IN schema_name[,...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]

for revokeing all tables/views in schema

Please review is it ok.

And I have question about what author of point in TODO list has on mind
when was writing

"GRANT SELECT ON NEW TABLES IN public TO phpuser;"?

What does "NEW TABLES" mean in this context?

Thanx for reply.

Sorry for my english.

--
Best Regards
Przemyslaw Kantyka
krycek6@wp.pl

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings