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]<javascript:_e({}, 'cvml', '[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] <javascript:_e({}, > 'cvml', 'h2-database%[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[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.
