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?
sakthikumarAsked:
Who is Participating?
 
Wasim Akram ShaikCommented:
ALL_TAB_PRIVS data dictionary view has the information you need.
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
select *
  from user_tab_privs;

Open in new window

0
 
LaccaCommented:
select *
  from USER_OBJECTS;
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
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...
0
 
sdstuberCommented:
you also inherit object privileges from ROLES granted to your user, and from roles granted to those roles and so on.

To recursively search your direct privileges and inherited privileges try this...

Just change "YOUR_USER" to whatever username you're investigating.

    SELECT LPAD(' ', 3 * (LEVEL - 1)) || granted_role "User, roles and sys privs", description
      FROM (SELECT grantee, granted_role, 'Role' description FROM dba_role_privs
            UNION ALL
            SELECT grantee, privilege || ' on ' || owner || '.' || table_name, 'Object Privilege'
              FROM dba_tab_privs
            UNION ALL
            /* fake privilege query to get user names as a starting point (see START WITH clause) */
            SELECT NULL , 'YOUR_USER' , 'User'
              FROM DUAL)
START WITH grantee IS NULL
CONNECT BY grantee = PRIOR granted_role;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.