Hi Rami,
I have implemented for myown use a user defined function that has the
> following syntax:
> F.GRANT_RIGHTS('comma_separated_list_of_rights',
> '*|comma_separated_list_of_schemas', '*|comma_separated_list_of_users')
> With this you can grant a set of rights to any number of schemas to any
> number of users.
> The implementation was 30-40 lines.
>
> The problem is that when I do development I have to run my GRANT_RIGHTS
> statement over and over again when I drop and recreate a table (with some
> changes).
> So the useful feature would be that giving rights to all objects in a
> schema would mean all objects now and in the future.
>
I think the MySQL implements such feature.
If someone else starts creating new tables in the same db for some other
> purpose then it would make sense that he would create a new schema for that
> new purpose, no?
>
I have cases in my job that fits in my previous post, where there are
schemas shared by different users, but not all tables in the related
schemas are necessarily shared. My main concern is about privileges be
granted automatically and some changes be executed by unexpected users. On
the other hand, I agree (by ignoring my previous concern) that would be
very helpful the permissions in the schema be valid for the related tables
in any time.
Regards,
Fred
--
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.
