Who created the folder c:\temp ?
If it was not created by your standard user account, you may have no rights
to write into it. Please check the r/w rights access to it, even a simple
file copy into it will give you a clue.
For me this works as I created the folder c:\temp myself with a standard
user account. I tried with version 1.3.176
On Tuesday, January 3, 2017 at 9:59:42 PM UTC+1, Chris Sunderland wrote:
>
> It doesn't appear that CSVREAD is requiring admin rights per the
> documentation. However CSVWRITE properly throws an error if I try to
> execute this as a standard user:
>
> Exception in thread "main" org.h2.jdbc.JdbcSQLException: Admin rights are
> required for this operation; SQL statement:
> CALL *CSVWRITE*('c:/temp/test.csv', 'SELECT * FROM TableA'); [90040-176]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
> at org.h2.message.DbException.get(DbException.java:178)
>
> I am using H2 version 1.3.176.
>
>
>
--
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
