Skip to Content

HANA DB User/Role Export

Feb 23 at 08:39 PM


avatar image

We are running HANA1.0 SPS12 and would like to understand how to perform an export of all users at the DB layer (without a full DB backup/restore). To clarify not necessarily looking to export the schema (there would be no objects under the user's schema), but rather security and all assigned roles. For example, if multiple users were deleted, could we periodically schedule an export so that that a particular user's ID and assigned roles could then be imported rather than restoring the entire database? Another option, could we script the user and assigned roles as a CREATE statement (similar to what's available in SQL Server at the database layer)?


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Michael Healy
Feb 25 at 02:23 PM

What you are looking is not possible with HANA.

10 |10000 characters needed characters left characters exceeded