missymadi
asked on
Check permissions for operations on a Oracle db table
Hi,
In Oracle 10g, how would I check to see that only the appropriate accounts have permissions to perform select, update, delete etc on the audit data table? Is this done through the GUI or is there an SQLPLUS command I can run to see the permissions?
Thanks, MissyMadi
In Oracle 10g, how would I check to see that only the appropriate accounts have permissions to perform select, update, delete etc on the audit data table? Is this done through the GUI or is there an SQLPLUS command I can run to see the permissions?
Thanks, MissyMadi
Also you could use the OEM console or any GUI like SQL Developper or TOAD.
ASKER
Is it possible to run a command in SQLPLUS to show who has priviledge to this table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check the DBA_TAB_PRIVS table.