On 2015-04-09 12:51 PM, Fred&Dani&Pandora&Aquiles wrote:
Ok, I'll try to make it better.

    If a user performs a GRANT and then later on adds a new table to a SCHEMA, 
the GRANT will not apply to the new table
    in the SCHEMA.


Sorry, I can't understand. Do you mean this?


I mean that, as a user, I expect that if I do this:

grant select on schema public to new_role;
create table public.new_table(id int primary key);

then the role 'new_role' will automatically have the select right on the new 
table.

You're going to have to modify the org.h2.command.ddl.GrantRevoke class and various other database internals to directly store the fact that 'new_role' has the 'select' right on schema 'public'.

Sorry, it's not a very easy thing to start with.

Regards, Noel

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to