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.
Published on 19-Dec-2017 09:27:16