Re: Question about privileges

From: damorgan <damorgan_at_exesolutions.com>
Date: Tue, 19 Mar 2002 17:15:52 GMT
Message-ID: <3C977256.8BE1758D@exesolutions.com>

No. But you can easily write an anonymous block or stored procedure that will do the heavy lifting.

Daniel Morgan

Ryan Gaffuri wrote:

> I saw somewhere that I cant grant permission to access a table by
> using a role in order for someone to access it with stored code.
>
> I know that I can grant all on each table. Is there a way to grant all
> on every table to someone in one command or grant all to someone where
> each table is 'like' with a '%' in it?
Received on Tue Mar 19 2002 - 11:15:52 CST