sententia
Home    Blog

Blog

Home  /  Blog
      
Nov 20 at 2:56pm | 0 comments
A table in another schema that my user has select on (via a role) was not usable in an oracle procedure.  I kept getting these errors when I tried to compile
ORA-24344: success with compilation error
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
 
 
Bottom Line:  It appears that procedures don't respect roles and the grant needs to be applied directly to the user.


Calendar

<November 2015>
>>SunMonTueWedThuFriSat
>25262728293031
>1234567
>891011121314
>15161718192021
>22232425262728
>293012345

Show All

Archives

May 2024  (3)
July 2023  (1)
May 2023  (1)
July 2020  (1)
July 2019  (1)
June 2019  (2)
May 2019  (1)
July 2018  (1)
November 2015 (1)
July 2014  (2)
June 2014  (2)
May 2013  (1)
June 2012  (10)
July 2011  (5)
June 2011  (10)
May 2011  (10)

Categories

Skip Navigation Links.

Subscribe

Rss