Link to home
Start Free TrialLog in
Avatar of missymadi
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
Avatar of MikeOM_DBA
MikeOM_DBA
Flag of United States of America image


Check the DBA_TAB_PRIVS table.

Also you could use the OEM console or any GUI like SQL Developper or TOAD.

Avatar of missymadi
missymadi

ASKER

Is it possible to run a command in SQLPLUS to show who has priviledge to this table?
ASKER CERTIFIED SOLUTION
Avatar of MikeOM_DBA
MikeOM_DBA
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial