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.