SAP SQL Anywhere

Question

SQL Anywhere 16.0.0.2546.
Let's create a database with a standard password (sql) for DBA.
Let after some time we changed the password for DBA. For example:
ALTER USER DBA IDENTIFIED BY test;
If now we want to make unload/reload database using reload.sql-file, then we lose the new password (test) for DBA. Please, look reload.sql:
GRANT CONNECT TO "DBA" IDENTIFIED BY sql go

I'll remind you that the "-up" option is not in the version 16.

Answer 1

1

The DBA password that is set near the beginning of the reload.sql script is only temporary. Have a look at the end of the reload.sql file: the script will set the DBA's password to the one in the database there.

-------------------------------------------------
--   Set DBA password
-------------------------------------------------
GRANT CONNECT TO DBA IDENTIFIED BY ENCRYPTED '...escaped-hex-string...'
go

HTH

permanent link

answered 08 May '18, 08:03

Mark Culp
24.8k●9●139●296
accept rate: 41%

Thank you.
Indeed, for a "normal" database, we get:
GRANT CONNECT TO DBA IDENTIFIED BY ENCRYPTED '...'
But if there is a "secret" administrator (for example ADM) and the DBA-user is deprived of administrator privileges (REVOKE DBA FROM DBA ), then
DBA-password (<> sql) is lost. That is, we do not see GRANT CONNECT TO DBA IDENTIFIED BY ENCRYPTED.
We look only:

----------------------
--   Create users

GRANT CONNECT TO "dba" IDENTIFIED BY sql
go
...

--   Remove or modify DBA userid
GRANT CONNECT TO "adm" IDENTIFIED BY sql
go
CONNECT USING 'UID=adm;PWD=sql'
go
BEGIN IF EXISTS (SELECT * FROM SYS.SYSUSER WHERE user_name = 'SYS_AUTH_DBA_ROLE') THEN REVOKE DBA FROM DBA END IF; END; 
go
GRANT CONNECT TO "adm" IDENTIFIED BY ENCRYPTED '...'
go`

(10 May '18, 02:53) Ilia63

3

We have reproduced this and are investigating a solution. Please note that this problem does not appear in v17. This issue is being tracked as Engineering Case# 814977 and will be available in an upcoming update.

(14 May '18, 09:58) Chris Keating

flat view

SAP SQL Anywhere

SQL Anywhere 16: unload/reload via reload.sql and password for DBA

-- Remove or modify DBA userid

Follow this question

Related questions