Need help on views/packages

[former_member198680]

Hi Experts,

We have created a package and created some views. we see some other user created few views in this package. We want to know who created these but could not. When the calv view is opened, it shows the activated by as 'SYSTEM' and changed by as space. Need help

1) views are showing as SYSTEM, is this because my user missing any auth to see those details? If yes, what is that required?

2) How to find out who created these views? Is there are any sys table to get the view properties?

Thanks,

Prasad

[anindya_bose · Accepted solution]

Hi Prasad

If you right click on any view and choose History  it shows you who activated that view .

In your case, it is showing SYSTEM, then someone perhaps logged in with "SYSTEM" ID and created some views.

So, you need to find out who has password for SYSTEM user id.  It would be better to ask your Basis team.

Cheers

Anindya