I want to get list of all objects which is accessible to the login user. The list should include Table, Sequence, Function, Procedure, View, Sequence, Index, Trigger etc.
I am using Oracle 11g and Oracle 12c. My requirement is that the owner of the db objects grant privileges to other user, so that user can access those objects by running select or other query. I did try earlier
dba_objects but DBA does not allow to grant permission for
dba_objects to the user. So I am looking for different solution.
I did try
all_objects that list of all objects accessible to the user, but It lists the Table, View, Index and Sequence only.
Either I am missing something or its returns it only.
Can anybody suggest me correct way to get all accessible objects to the user?