What is the best way of checking the current user privileges on a particular table from another schema? In my software, at runtime, I need to check if the connected user has the privileges on some tables, across 2 different schemas.
From what I found doing research, I came across these 2 views
ALL_TAB_PRIVS_RECD 
ALL_TAB_PRIVS
Should I use one of these views, or is there another better way to do it?
Thanks
ALL_TAB_PRIVS is a superset of ALL_TAB_PRIVS_RECD. You probably want ALL_TAB_PRIVS as it includes tables that the current user owns.