Skip to Content

role in dependancy object.

I have a CV, when i see where used list I could find two uses of it.

1. In another CV.

2. In a role.

when i see the table "SYS"."OBJECT_DEPENDENCIES" I couldn't find the role as a dependency object.

Does it mean anything.

Actually my aim here is to delete the CV, can I delete the CV without changing role.

Can anyone throw some light over this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 29, 2016 at 08:27 AM

    The OBJECT_DEPENDENCIES view does not list dependencies to roles (this is so cause of the setup of the underlying OBJECTS view). So this is not an issue.

    But you cannot delete the CV in a consistent way w/o adjusting the role too. When you delete the CV you will get an error for the role object that the CV is missing. So you have to first remove the CV from the role and then delete the CV to have a consistent implementation.


    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02, 2017 at 11:22 PM

    Florian is right about the state of documentation of OBJECT_DEPENDENCIES.

    In I provides some more information - based on what I could make out of the view's content.

    For most practical matters of development/deployment dependency handling, DEPENDENCY_TYPE 1 and 2 are the most relevant ones (direct and indirect dependency).

    For your question about roles: it's good to remember that OBJECT_DEPENDENCIES shows runtime dependencies, that means the dependent objects are not guaranteed to continue to work if the object they depend on gets changed.

    For roles, that's different as if you change, e.g. a table the role does not change and does not stop to function properly. If you delete a table covered by a role, all that will happen is that the role will not be triggered anymore for this table (as it is not existent anymore).

    However, upon activation of a role, it will be checked that all referenced objects exist at that point in time.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Lars Breddemann,

      I got an answer for the question i have been searching for(full dependency network of all objects)

      This the the table which will be helpful in this case.


      also to some extent if we search dependencies in reverse way(reversing base object and depend object in our search) in the OBJECT_DEPENDENCIES will gives better result.

      One more info in this context was that the access to _SYS_REPO tables will not be there in future releases.

      Can you give any point why this could happen.

      Also i couldn't find any documentation on this _SYS_REPO tables.