Frequently Asked Questions
How to create schema (user) in HANA SQL
CREATE SCHEMA "SANDBOX";
CREATE USER USERNAME PASSWORD "yourpassword" NO FORCE_FIRST_PASSWORD_CHANGE ;
GRANT SELECT ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT UPDATE ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT INSERT ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT DELETE ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT EXECUTE ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT CREATE ANY ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT DROP ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT "IMPORT" TO "USERNAME";
CREATE USER USERNAME PASSWORD "yourpassword" NO FORCE_FIRST_PASSWORD_CHANGE ;
GRANT SELECT ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT UPDATE ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT INSERT ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT DELETE ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT EXECUTE ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT CREATE ANY ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT DROP ON SCHEMA "SANDBOX" TO "USERNAME" WITH GRANT OPTION;
GRANT "IMPORT" TO "USERNAME";
Last Updated 5 years ago