Re: all_tab_columns in a stored procedure?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 27 Jul 2002 10:14:47 +0200
Message-ID: <uk5eldmufrfq6d@corp.supernews.com>

"Jusung Yang" <jusungyang_at_yahoo.com> wrote in message news:42ffa8fa.0207262310.3a1e6ffd_at_posting.google.com...
> This is one of those FAQs. Roles are disabled within stored
> procedures. In SPs, you may not have access to some objects granted to
> you thru roles - which makes querying ALL* views within SPs somewhat
> dangerous. Do a direct grant if you have to.
>
>

or create the procedure with authid current_user in Oracle 8i and higher (which is better practice)

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Sat Jul 27 2002 - 03:14:47 CDT