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’
I tried to give different rights to users, set other options, but nothing helped
How can I solve this problem?
I couldn’t find any information on the Internet
Дима Антимаг is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.