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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: What privilege needs to be granted?

Re: What privilege needs to be granted?

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 02 Jan 2004 18:10:38 GMT
Message-ID: <3FF5B3B5.5D4639A7@yahoo.net> 






Ping wrote:


> 

> In schema U2, the select count(*) from U1.T1 gives following error message:

> 

> ERROR at line 1:

> ORA-01031: insufficient privileges




Have you done a 'grant select' from U1 on T1 to U2?



What ROLES do U1 and U2 have?
Received on Fri Jan 02 2004 - 12:10:38 CST












Original text of this message













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