Re: Pl/SQL : better soltions

On Fri, 11 Aug 2000 21:14:55 GMT, zyman_at_my-deja.com wrote:

>Hello,
>Need advise how to resolve the situation below better:
>I have stored procedure ( btw. user has DBA role) and I make a select
>from
>sys.col$ , sys.obj$ , sys.obj$, sys.user$, sys.coltype$ tables to get a
>description ( columns, types) of the object ( either table or view )
>from the other user scheme. Such select works in sqlplus, but it doesn't
>in stor. procedure. I don't want to give grants on sys.col# and other
>tables to this user and this is the reason why I'm looking for better
>opporunity to resolve this question.
>Thank You
>

Create the stored procedure under a user that has full DBA rights and grant EXECUTE right to it to the normal user.

HTH Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sat Aug 12 2000 - 00:00:00 CDT