Hi,

I am struggling to run SQL statements (UPDATE) on my universe files.  If we run the same command as a root user then the SQL command is successful.

This would indicate a permissions problem.

Does anyone know which files need to be given permissions to, in order to  allow SQL updates on normal Univere files ?

Thanks,

Greg

Hi Greg,

Do you get any kind of error message for the non-root user? 

For a standard UV file, I think you should only need permissions on the file on which the UPDATE is being performed. 

Although, the UPDATE process does run as a transaction so if TXMEM is exceeded, creating a "cache" file in uvtemp may be required.

You could try using the 'strace' command as I believe you are running Linux. 

For example,

# strace uvsh "UPDATE FILE SET F1 = 'test';"

and compare the results between the root user and non-root user to see where it is different. 

Thanks,

Neil