Re: Can't select from ALL_TABLES in a stored procedure

Seems like the only/best solution is to not use roles for the 1 account that needs this Plsql . For this 1 account, do the grants directly to the account. You could still use the role for other accounts.

But, why are you writing this Plsql? Given the reason, someone could maybe come up with a better solution.

"Ivan Petrovski" <ivan_pet_at_hotmail.com> wrote in message news:bnepns$vtj$1_at_ls219.htnet.hr...
> > Roles are not enabled in a procedure.
> > Execute "set role none" and then your statements in SQL*Plus and I bet
> you'll get only 64 records.
> >
> > Hope this helps
> > Michel Cadot
> >
> >
> Thanks, this helps me produce the undesired behaviour ;-)
> But what should I do? Will it work if DBA grants me select on all_tables?
>
>
Received on Sat Oct 25 2003 - 20:02:34 CDT