Hi,
I have granted select privilege on view to user at that time it got completed successful. But customer is asking he dont have access on that view. Is there any chance to check privileges on views to user in oracle 11g.
Thanks in advance
Printable View
Hi,
I have granted select privilege on view to user at that time it got completed successful. But customer is asking he dont have access on that view. Is there any chance to check privileges on views to user in oracle 11g.
Thanks in advance
User_tab_privs
You might also check dba_Dependencies for what grants are needed for a particular view.
Hi gandolf989
I have already granted select privs on view but i need to check it now but am not able to check which privs i have granted to user on particular view.