oracle - How can I ensure a grant has been performed? -

in oracle, when run:

grant select on myschema.orders app_user; 

what query can run in oracle check if grant exists? validate grant correctly created in our development, qa, , production databases.

you can all_tab_privs performance view, or user_ or dba_ equivalents depending on situation , privileges:

select * all_tab_privs table_schema = 'myschema' , table_name = 'orders' , grantee = 'app_user'; 

to see has access, leave off grantee filter. note though grantee may (and quite should be) role, not individual user. in case you'd need see has role granted full picture, , roles can granted roles, can bit recursive.