Re: Stored procedures ignore grants
From: Tim Boemker <tim_boemker_at_zacatecas.optimum.com>
Date: 23 Dec 1994 14:05:30 GMT
Message-ID: <3delfa$elj_at_jalisco.optimum.net>
Date: 23 Dec 1994 14:05:30 GMT
Message-ID: <3delfa$elj_at_jalisco.optimum.net>
In article <3dd294$e26_at_lll-winken.llnl.gov> 68a869_at_llnl.gov (Jeff Busch) writes:
> I have found that I cannot compile a stored procedure which selects from
> another user's table if my grant on that table is role-based.
I had a similar experience. I discovered that a stored procedure runs with exactly the directly granted privileges of its owner. For example, if I run one of my own stored procedures, I can't use any privileges I hold via roles. In this case, running a stored procedure reduces privileges.
Tim Boemker Received on Fri Dec 23 1994 - 15:05:30 CET