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 -> Re: Give user index grants Oracle 8/9i

Re: Give user index grants Oracle 8/9i

From: Sean <seanm555_at_comcast.net>
Date: 17 Nov 2006 21:09:32 -0800
Message-ID: <1163826572.249830.174170@h54g2000cwb.googlegroups.com> 





After digging around some, it appears ADO recognizes the primary key on
the table for non-owner users if you address the table with the
<OWNER>.<TABLE> specification in your query.  If you use the synonym
specification of just <SYNONYM> for the table, the primary key
information isn't recognized.  Why is this?
Received on Fri Nov 17 2006 - 23:09:32 CST












Original text of this message













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