Ok, thanks Thomas. On Thu, Dec 5, 2013 at 1:57 PM, Thomas Mueller <[email protected] > wrote:
> Hi, > > Both SCRIPT and CSVWRITE can currently only be executed from an admin user. > > > Is it possible to prevent people from issuing these certain commands? > > As for built-in commands and functions, access right checks are in place. > For user defined functions, you would need to check yourself within the > function if restrictions are needed. > > Regards, > Thomas > > > > > On Wed, Dec 4, 2013 at 10:44 AM, Atul Chowdhury > <[email protected]>wrote: > >> Hi - >> >> Our application provides a SQL "worksheet" where users can manipulate >> data similar to H2 Web interface. >> >> However, we do *not* want to expose the ability for users to "walk away" >> with the data. H2 of course provides (very useful) ways for ones to do >> this. >> >> Question: Is it possible to prevent people from issuing these certain >> commands? I don't see any way to prevent this at the ROLE/GRANT RIGHT >> level; maybe someone has an idea around this? >> >> thanks - >> >> AC >> >> -- >> 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/groups/opt_out. >> > > -- > 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/groups/opt_out. > -- 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/groups/opt_out.
