Skip to Content
avatar image
Former Member

Renaming an SAP HANA Schema

Hello,

Is there a way to find invalid objects belonging to users that have been dropped. For example, we had a few BI developers develop their own views using their login names. Once they moved on, the security team dropped their logins. Unfortunately, these objects are still referenced/linked to the _SYS_BIC schema. During an export/import w/ schema rename of the original base schema, we encounter errors related to these objects.

Is there a way to identify these objects before we start the export/import process ?

SAP HANA 1.22.04
SUSE Linux 11 SP3

Thank you in advance...

Cheers,

/gxo13

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 25, 2017 at 10:06 PM

    check if deleting the deleting the user, removes their schema and therefore all the objects tied to them.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2017 at 04:20 AM

    That's expected and documented behaviour. When dropping tables, dependent objects like views or synonyms don't automatically get dropped.

    Instead, the dependent objects get invalidated. This provides the option to check for invalidated objects after the base objects have been dropped. (E.g. system table VIEWS has a IS_VALID field).

    With this information, you can create a list of invalid objects and make sure that all of them are corrected or deleted before you transport your development.

    Add comment
    10|10000 characters needed characters exceeded