Awesome. I ended up solving the problem by building H2 from source and removing all of the functions and statements that can access files other than the database's data/index/etc files.
On Jan 24, 9:25 am, Thomas Mueller <[email protected]> wrote: > 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 > alsohttp://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.
