openolz.blogg.se

GRANT REPO.MAINTAIN_NATIVE_PACKAGES ON _SYS_REPO."a-project-package-name" TO A_PROJECT_NATIVE_PACKAGE_ROLES_元 GRANT REPO.ACTIVATE_NATIVE_OBJECTS ON _SYS_REPO."a-project-package-name" TO A_PROJECT_NATIVE_PACKAGE_ROLES_元 GRANT REPO.EDIT_NATIVE_OBJECTS ON _SYS_REPO."a-project-package-name" TO A_PROJECT_NATIVE_PACKAGE_ROLES_元 GRANT REPO.READ ON _SYS_REPO."a-project-package-name" TO A_PROJECT_NATIVE_PACKAGE_ROLES_元 priviles required to update native (created) objects in dev environment

GRANT EXECUTE ON SCHEMA SYSTEM TO _SYS_REPO WITH GRANT OPTION GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON SCHEMA "A_PROJECT_SCHEMA" TO _SYS_REPO WITH GRANT OPTION Without it you get an error at the flowgraph execution level GRANT EXPORT, IMPORT TO A_PROJECT_SYS_REPO_ROLES_元

GRANT EXECUTE ON REPOSITORY_REST to A_PROJECT_SYS_REPO_ROLES_元 GRANT SELECT ON SCHEMA "A_PROJECT_SCHEMA" TO A_PROJECT_ALL_READ_ROLES_L2 Prefix any users with a project name will make it clear who is doing what within a specific hana database. You can also validate and certified a user and its privileges via an SQL script where as via sap hana studio any privileges can be assigned to a user one day and the next day nobody knows what has really been done.Īs Sap hana is very tied up to sap applications, it is very important to differentiate project users from any other type of users you can find in the sap hana database. You can retrieve which privileges should be assigned to a user. It is very fast to update name and privileges user profile. It is possible to create many users at once. SQL scripts have many advantages and is also preferable when it comes to recreate users in another environment. How to create developer users for a sap hana data provisioning projet?Īlthough sap hana studio is very easy to use, the best way to create hana users is to use SQL script.

Refresh data from another tenant database.