Hi, > I do, however, want users to have admin rights
That's dangerous. The admin can do everything, including dropping a database. The current access rights system of H2 is quite simple. Tables don't know who created them. I guess to solve your use case, the access rights system would need to be extended so that non-admin users can create databases objects and automatically get access rights to those objects (including the rights to drop them). That's currently not supported. There are two feature requests: "Access rights: remember the owner of an object." and "Access rights: finer grained access control (grant access for specific functions)". I will increase the priority of those, however I don't know when I will have time to implement them. If you want, please go ahead - see also http://www.h2database.com/html/build.html#providing_patches Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
