Guest User | Sign In

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";


 Last Updated 5 years ago

Please Wait!

Please wait... it will take a second!