How to setup user access limitation on a timely basis in SAP HANA


I must say, you got a pretty odd scenario of permission retraction but it is feasible.

  • Create a stored procedure with entire onus of activating/deactivating the user or you can say authorize and de-authorize user.
  • Create a batch user with privilege to execute the above-created procedures,
  • Then you can set up a job to run the procedures with the help of hdbsql.

Updated on: 10-Dec-2019

46 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements