How to unlock user in sap hana studio
![how to unlock user in sap hana studio how to unlock user in sap hana studio](http://www.sapbasistuts.com/_/rsrc/1418673801678/home/hana-administration/hana-administration-wiki/how-to-check-sap-hana-schema-owner/HANA_SCHEMA_OWNER.png)
Indeed it only scratches the surface and there are a lot more information on security mechanisms and best practices available.Īnd for a good posting I'd wish that this material would have been considered. I agree with Florian that the depth and extent of how the topic had been addressed in the blog post is not advanced. Good discussion of this blog post and I think both of you have valid points. Please let me know if I need to clarify any other points. I am hoping that others having similar issues could ask more questions such as yours. It may all be documented but depending on the topic, there may be a looooot out there as you probably agree with me on this one. Some of the pitfalls include the understanding of how schemas, roles and users and finding the documentation in the vast amount of official documentation. It will make more sense on my next blog what the complexity of the next security points are. This blog is from my own experience and also showcasing the simplicity of the exercise. however, I always depended on the db admins, or someone else with such privileges to get this accomplished. I am sure there is tons of materials on scn, youtube, openSAP, etc.
#HOW TO UNLOCK USER IN SAP HANA STUDIO PLUS#
before I answer your question, let me take a step back and mention that I am working on a demo which requires this type of security plus another types (next blog in my series) Regarding your question about pain points, I wanted to address my demo and capture screenshots for my scenarios as well as hoping to help others with similar issues. Please share your experiences and/or questions. Thirdly, we need to create the users (if not existent) and assign such roles to their Granted Roles tabįinally, we will test these scenarios for the READ ONLY UserĪnd now the same tests with the Read/Write user (and role)Īnd verify that it works ( Rows affected: 1) Secondly, we will need to create the roles and assign a) read access to the schema and b) read/write access to the schema. GRANT ON SCHEMA MYSCHEMA TO SOMEUSER WITH GRANT OPTION I started by going to the documentation and ran the statement below a few times (this works but there is an easier and more manageable way to accomplish the task) please go to Secondly for a better way The owner of the schema or someone with owner privileges of the schema should be able to accomplish this task.
#HOW TO UNLOCK USER IN SAP HANA STUDIO HOW TO#
( read only and read & write) and how to assign these roles to a user.įirst we need to have a SCHEMA where we can assign these roles to certain users. In this blog, I am going to showcase how to create users and roles Welcome again to my series of blogs on Users/ Roles / Security.