From: | "Walter Cruz" <walter(dot)php(at)gmail(dot)com> |
---|---|
To: | Krycek <krycek6(at)wp(dot)pl> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Granting all tables in schema by one SQL command |
Date: | 2006-10-19 20:27:26 |
Message-ID: | 32cabba0610191327s243b089q3525ec5c123073c4@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
looks to me that NEW TABLES are the tables created AFTER the GRANT :)
Is that?
[]'s
- Walter
On 10/19/06, Krycek <krycek6(at)wp(dot)pl> wrote:
>
> 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(at)wp(dot)pl
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2006-10-19 20:28:01 | Re: Asynchronous I/O Support |
Previous Message | Magnus Hagander | 2006-10-19 20:21:00 | oid2name optargs |