- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- Disabling JDBC/ODBC access to SAP HANA system for a new user
- TCP/IP port in SAP HANA to access SAP HANA XS Engine
- Creating a Restricted user in SAP HANA
- Searching a user in SAP HANA system using HANA Studio
- Setting validity of a user in SAP HANA
- SQL statement to create a Restricted user in SAP HANA
- Defining user lock settings in SAP HANA
- Create User SQL in SAP HANA database
- SAP HANA Vora access free signup
- Adding PUBLIC role to restricted user in SAP HANA
- Adding LCM Administrator role to a user profile in SAP HANA
- Connection used in SAP HANA Smart Data Access
- Managing cross database container access in SAP HANA
- Using Smart Data Access SDA in SAP HANA
- Use of Restricted user in SAP HANA system

Advertisements