home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 894 of 2,288   
   Hans Forbrich to Ping   
   Re: What privilege needs to be granted?   
   02 Jan 04 18:20:51   
   
   From: forbrich@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   
      
   Your problem is therefore NOT in the PL/SQL routine.  It is a basic   
   accessibility problem.   
      
   Now might be a good time to reread the following documentation:   
      
   Oracle9i Database Concepts:  Chapter 23   
   Oracle9i Database Administrator's Guide: Chapters 25, 23 & 24   
      
   both being available at http://docs.oracle.com   
   (http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca