Dba's are not granting select permission on any sys.all_* views based on the security policy by Oracle . see the policy violation alert from OEM.
Category :Security
Description :Ensures Select privilege is never granted to any DBA .
but we have access to user_tab_columns.
thanks
pldev
Hello
Getting error when select column in the select list. what permission do i need?
example:
i logged into the database as schema owner . say scott/scott
when write select statement..
SELECT EMP.
i get an error saying table/view does not exist.. Why am i getting this error .
I am the...