Re: a question for stored procedure

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1996/02/26
Message-ID: <Pine.SUN.3.91.960226090442.2163A-100000_at_seatimes>#1/1

On 22 Feb 1996, Mark Styles wrote:
> I thought maybe it was because dba_objects is a synonym, so tried
> changing it to sys.dba_catalog, but still got the same errors.
>
> I then thought maybe it was because sys.dba_objects is a view, so
> created a view as another user, and tried to reference that, but
> this worked fine!
>
> The only conclusion I can come to is that the data dictionary tables
> are 'special' in some way, a conclusion I am not very happy with!
> Can anybody do any better?

Privileges granted by a role can't be used within a stored procedure. You need to be granted access as the user directly rather than through a role.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Mon Feb 26 1996 - 00:00:00 CET