Link to home
Start Free TrialLog in
Avatar of sakthikumar
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?
ASKER CERTIFIED SOLUTION
Avatar of Wasim Akram Shaik
Wasim Akram Shaik
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
select *
  from user_tab_privs;

Open in new window

select *
  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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial