SAP SQL Anywhere

Question

Earlier I thought that it would not make sense to change the contents of the dbo-owner's procedures.
But it turns out (ASA 12.0.1.4436, 16.0.0.2419) that one can not create dba-"namesakes" for dbo-owner's procedures:

 - Create a dba-"namesakes" procedure (the reasons for this are omitted). Fоr example, call sa_make_object('function', 'xp_cmdshell', 'dba')
  ==> select creator, procname from sys.SYSPROCS ...
        creator,procname
        'DBA','xp_cmdshell'
        'dbo','xp_cmdshell'
 - Unload the database completely (all objects). For example, dbunload -v -c "DSN=SQL Anywhere 16 Demo;UID=dba;PWD=***" -r "reload16.sql" -n

 - We do not find a new "dba"."xp_cmdshell"-procedure in the "reload16.sql"-file.

Is this correct behavior?

Accepted Answer

0

This issue was fixed in December of 2015 and included in the v17 release.

If a user owned a table or procedure with the same name as a system table or procedure (eg. a user with an “sa_split_list” procedure), that object would not be included if the databases was unloaded with dbunload. This has been fixed.

Since the fix involves changes to the unload, upgrade, and database creation scripts, it will not be pushed back into existing branches.

permanent link

answered 20 Apr '17, 08:37

Mark Culp
24.9k●10●139●297
accept rate: 41%

1

Thanks.
Of course, I'd like to see this fix in v16 :(

(21 Apr '17, 03:20) Ilia63

flat view

SAP SQL Anywhere

Unload stored dba-procedures that have the same name as the dbo-owner's procedures.

Follow this question

Related questions