sakthikumar
asked on
How can I check the list of objects which my user is having access?
I assume all_objects view will provide me the list of objects which my user can access.
But I found a few tables which does not find a place in this view, but still I am able to access.
If my assumption is not correct, How I can check the list of objects which my user having access?
But I found a few tables which does not find a place in this view, but still I am able to access.
If my assumption is not correct, How I can check the list of objects which my user having access?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select *
from USER_OBJECTS;
from USER_OBJECTS;
select *
from USER_OBJECTS;
These are just those objects which are owned by the logged on user, not neccessarily those which this user is allowed to access...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window