Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4560
  • Last Modified:

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
0
missymadi
Asked:
missymadi
  • 3
2 Solutions
 
MikeOM_DBACommented:

Check the DBA_TAB_PRIVS table.
0
 
MikeOM_DBACommented:

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

0
 
missymadiAuthor Commented:
Is it possible to run a command in SQLPLUS to show who has priviledge to this table?
0
 
MikeOM_DBACommented:

SQL> SELECT * FROM DBA_TAB_PRIVS WHERE TABLE_NAME = 'MY_TABLE';

Open in new window

0
 
dbmullenCommented:
select *
from dba_tab_privs
where owner = 'SYS'
  and table_name in ( 'AUD$', 'DBA_AUDIT_TRAIL')
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now