Get access to other users HANA schema

[former_member661968]

We have a demo S/4 system and I would need access to its HANA schema. The password is unknown for the HDB user of this schema, and the SYSTEM user also has no privilege to this schema.

Is there any other way to get access to this schema?
I don't want to reset the password - not sure which impact this would have for the S/4 installation.

[michael_eaton3]

Without changing the password, the only way is to GRANT access to another user. Ideally you wouldn't use SYSTEM, but as you don't have the setup passwords for the S/4 system we're off reservation already! 😉

Log into S/4 as an administrator, using DBACOCKPIT (or whatever's useful in S/4 - not my area) execute the following SQL

GRANT SELECT ON SCHEMA HDB (or whatever the S/4 instance is using) to SYSTEM