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
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
-
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
Add comment