on 09-24-2014 8:20 AM
Hello,
I had created a catalog schema DEMO. Then I created a DEMO.hdbschema and it got activated successfully. I granted all the permission to _SYS_REPO with Grant options.
I am not able to activate the .hdbrole created for DEMO.hdbschema and get the error "DEMO: schema is not owned by _SYS_REPO". Is there a workaround for this situation?
Hi Tarun,
I had the same problem when transporting a delivery unit from the DEV to Q HANA instance.
The following comment helped me:
http://scn.sap.com/message/14874069#14874069
_SYS_REPO should be automatically the owner when creating the Schema via the repository (.hdbschema). I deleted the schema on the target (Q) system and tried once more and didnt get the error anymore.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tarun,
I assume you've already thought about the option:
1. export the data
2. delete the objects
3. re-create the objects via the repository
4. re-import the data
?
Another comment:
The ownership can be viewed in the SYS.SCHEMA and SYS.OWNERSHIP view, see e.g.:
https://www.youtube.com/watch?v=4ZMfLHgOJXU
Markus
Hi Tarun,
Can you share your code?
Have you given the schema privilege as follows:
schema <Package path>:DEMO.hdbschema: CREATE ANY, SELECT, EXECUTE, INSERT, UPDATE, DELETE;
Regards,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.