DBA Privileges on SYS tables.

[Former Member]

Hello,

I am trying to formulate a script to change some permissions on SYSUSERPERM.

I login as DBA, and run the following command:

update SYSUSERPERM set dbaauth = 'T' where user_id = 104

I receive a 'Permission denied: you do not have permission to update SYSUSERPERM.

However, if I perform the privilege change directly through the Sybase frontend, the system allows me(dba) to perform the change.

Any ideas?

[justin_willey]

You can't change or insert values into system tables directly - you have to use the appropriate DDL command instead. When you use Sybase Central to make the change, you aren't editing the data directly, Sybase Central is executing the command for you.

You will need the GRANT statement:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.11.0.1/sqlanywhere_en...