oracle - How can I check if a role has "grant references" on a given table? -


i've got table (myschema.mytable) want grant select , references role (myrole).

so, when logged on "sys sysdba", executed following:

grant select, references on myschema.mytable myrole; 

i can see grant permission when execute:

select * role_tab_privs role = 'myrole' 

however, doesn't seem show references privilege. need query see that?


Comments

Popular posts from this blog

winapi - How to get a user input on a MessageBox on C++? -

parcelable - Unmarshalling unknown type code exception while reading parcel values in Android 4.4+ -