Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

Hi All,

Server SAP SA 17. Under it there are two bases, base1 and base2. The structure of these bases is the same. In base1 there are logins of 100 users. I need to transfer these logins (including their passwords) from base1 to base2. Ideally, you can also transfer the rights of these users.

Can this be done using system procedure or system table accesses ? If possible, please give an example for this.

P.S. The option of unloading the database in reload.sql I ask you not to offer, I know about him.

asked 27 May '19, 02:31

Stalker's gravatar image

accept rate: 11%

I guess you can use the newly introduced SYSUSERPASSWORD system view and use the "password" column (if filled) to generate fitting


statements, with adequte coding of the password hash.

(Nevertheless, running DBUNLOAD -n -up seems way easier IMHO, and might be necessary to help to generate the GRANT CONNECT syntax for the password hash anyway...)

permanent link

answered 27 May '19, 04:00

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 27 May '19, 04:02

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 27 May '19, 02:31

question was seen: 1,460 times

last updated: 27 May '19, 04:02