Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Confused by dba_tab_privs

Confused by dba_tab_privs

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca>
Date: Thu, 17 Oct 2002 19:13:28 GMT
Message-ID: <sZDr9.18328$Sk6.1769262@news1.telusplanet.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US