Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Confused by dba_tab_privs
I run the following query:
select * from dba_tab_privs
where grantee = 'PUBLIC'
and table_name like 'DBMS%'
order by owner, table_name
In the result I notice that there are a lot of duplicate records, e.g. dbms_job, dbms_transaction. ( 63 rows retrieved, 49 distinct rows). What could be causing this? Is it a reason for concern? Oracle 8.1.7.2.7 on W2K
-- Terry Dykstra Canadian Forest Oil Ltd.Received on Thu Oct 17 2002 - 14:13:28 CDT