--run with SYSTEM user
GRANT MODELING TO A001;  
GRANT CATALOG READ TO A001;  
GRANT CONTENT_ADMIN TO A001;
GRANT EXPORT TO A001;  
GRANT IMPORT TO A001;  
GRANT REPO.EXPORT TO A001;  
GRANT REPO.IMPORT TO A001;  
GRANT EXECUTE ON REPOSITORY_REST TO A001;
GRANT REPO.READ ON _SYS_REPO."zgd" TO A001;
GRANT REPO.EDIT_NATIVE_OBJECTS ON _SYS_REPO."zgd" TO A001;
GRANT REPO.ACTIVATE_NATIVE_OBJECTS ON _SYS_REPO."zgd" TO A001;
GRANT REPO.MAINTAIN_NATIVE_PACKAGES ON _SYS_REPO."zgd" TO A001;
GRANT REPO.READ ON "sap" TO A001;
GRANT REPO.READ ON "public" TO A001;
GRANT SELECT ON SCHEMA _SYS_BI TO A001 WITH GRANT OPTION;
GRANT EXECUTE ON SCHEMA _SYS_BI TO A001 WITH GRANT OPTION;
GRANT SELECT ON SCHEMA _SYS_BIC TO A001 WITH GRANT OPTION;
GRANT EXECUTE ON SCHEMA _SYS_BIC TO A001 WITH GRANT OPTION;
CALL GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE('_SYS_BI_CP_ALL','A001');

#run with A001 user
GRANT SELECT ON SCHEMA "A001" TO _SYS_REPO WITH GRANT OPTION;