How to create SAP HANA user using SQL Console




CREATE USER SAP4EASY PASSWORD OALPassword;  //This wll create user SAP4EASY with password : OALPassword
CREATE USER SAP4EASY PASSWORD OALPassword NO FORCE_FIRST_PASSWORD_CHANGE;  //This wll create user SAP4EASY with password : OALPassword without change password by user
GRANT SELECT ON SCHEMA SAPXYZ TO SAP4EASY //This will grant read access to SAP4EASY schema to user
GRANT ABAP_ADMIN TO SAP4EASY ;  //This will assign ABAP_ADMIN role to user
GRANT REPO.READ ON "oal-package" TO SAP4EASY  //This will give read access to package name 'oal-package ' to user.
GRANT EXECUTE ON REPOSITORY_REST TO SAP4EASY ; //This will give authorization to expand the "Content" folder to view the package.
ALTER USER SAP4EASY DISABLE PASSWORD LIFETIME;  //Password without timelimite


No comments:

Post a Comment