Skip to Content
avatar image
Former Member

HANA Repository roles transportation error with Schema

Hi, I'm trying to transport repository Role with Schema assigned(ex: DEV_SCHEMA) in Object privilege but when I try to move the role to Quality it throws an error.

I've schema mapping perfectly done in Quality System but I still face this issue.

Any solution?

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Hi Florian,

    Sorry for this, presuming this to be a regular error I haven't detailed this with screen shots, my apologies pleas find the error details and the DSL script used to create repository. (Reason for creating DSL script role is because nevertheless we were able to create graphical repository role using Web IDE but it isn't allowing us to assign object privileges)

  • Get RSS Feed

3 Answers

  • Best Answer
    May 21, 2017 at 01:51 PM

    Hi,

    Modeler uses the schema mapping definition to resolve the conflict for authoring to the physical schema for Information views.

    Also, roles grant privileges to objects to the user. Thus, using schema mapping may grant unintended privileges to users.

    Thus, on a repository role transport, the schema mapping will not take effect.

    One of the solutions could be to import the DU by selecting do not activate the objects (to not activate any object) or the activation mode as Activate and ignore inconsistencies in affected objects (to continue the activation of other objects) and then manually changing the role to specify the physical schema for the authoring schema.

    Note: This must then be performed with every import of the role.

    Thank you.

    Best Regards,

    Anjali.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 01, 2017 at 01:03 PM

    Hi,

    I've found a work around solution for this error which will avoid the manual process in activating all the roles.

    lets say if your schema in Dev is HANA_LIVE_DEV and in Prod is HANA_LIVE_PROD

    Create Dummy Schema with the same schema name as it is in production, in this case create HANA_LIVE_PROD in Development and create a role using Hana Development perspective with Domain Specific Language as shown below

    role XXXXX.SCHEMA_ROLE::Z_GLOB_SCHEMA {

    catalog schema "HANA_LIVE_PROD": SELECT;

    }

    Export this specific Package:XXXXX containing this Role:SCHEMA_ROLE from Dev and import the same into Production using SAP HANA Web based Workbench.

    Start using this role in assigning to users whomever required access to this Schema

    Regards,

    Swayam

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2017 at 01:42 PM

    Hi Swayam,

    This will work if you have 2 system landscape. What if you have Quality also in between?

    Regards,

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded