Relative Content

Tag Archive for sybasedatabase-administrationsap-iq

I cannot set TEMPORARY option

I created a database on sybase iq 16 to test some ETL processes
Created the DBA user and gave him all the necessary rights to the database
The problem is that when I try to set temporary option minimize_storage = ‘on’ I get an error “Cannot set a temporary option for user ‘DBA'”
When I change user I get the same error
SQL Anywhere Error -203: Cannot set a temporary option for user ‘PUBLIC’