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, 02:31

Stalker's gravatar image

Stalker
298151834
accept rate: 12%


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

GRANT CONNECT TO "username" IDENTIFIED BY ENCRYPTED "password"

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, 04:00

Volker%20Barth's gravatar image

Volker Barth
33.8k332487717
accept rate: 33%

edited 27 May, 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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×15
×8

question asked: 27 May, 02:31

question was seen: 332 times

last updated: 27 May, 04:02