Home -> Usenet -> comp.databases.oracle -> grants and all_tab_columns

grants and all_tab_columns

From: Joe Mellors <joemellors_at_aol.com>
Date: 10 May 2002 11:30:25 -0700
Message-ID: <53566469.0205101030.25387100_at_posting.google.com> 






I hope someone has the answer to this cause I'm stumped :
I've created a package and within a procedure in it am doing a select
statement on all_tab_columns to get data_type and data_length for a
column on a table owned by someone else. I realise all_tab_columns
only shows you the tables you have access to so select is granted to
the owner of my package on the other owner's table and yet when I run
the procedure from SQL plus it returns a no_data_found exception. When
I do the same select statement from SQL plus logged on as the same
user I get the row. Can anyone shed any light ?



Regards,



Joe Mellors
Received on Fri May 10 2002 - 20:30:25 CEST












Original text of this message