![]() ![]() It allows copying a user to a single target user. If you need to automate copying of users, you might find the procedure below helpful. ![]() The copy process is purely a UI functionality, and thus cannot be automated. If you are operating a well-managed HANA system, this will be fine, because SAP’s recommendation is to only grant repository roles to end-users do not make use of catalog roles and never grant privileges directly to end users. In the SAP HANA studio, there is since about SPS 7 a possibility to copy database users – with one restriction: the only user properties that will be copied are the assignemts of repository roles (aka design-time roles). In that process, she would also need to assign the SELECT privielge on schema JIM to the new user – but does SYSTEMA have the required privileges? She probably won’t, and thus the process of copying the user would fail. ![]() Now assume another database user, let’s call her SYSTEMA wants to copy user Bob. Jim owns a database schema named “JIM”, and for whatever reason has given Bob the permission to work in that schema, that is, Bob has object privileges sucha s SELECT on schema JIM. While this is not a real challenge for role grantings, the privileges granted directly to end-users are what makes a generic user copy mechanism impossible.Īs most simple example, consider that you have two users, Jim and Bob. The most important reason for the lack of a generic user copy mechanism is in the course of a user copy, all privilege and roles assignments shall be copied as well. As most readers will be aware, database users in SAP HANA are non-copiable entities. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |