Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using GRANT in PL/SQL

Re: Using GRANT in PL/SQL

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 01 May 1999 02:11:51 GMT
Message-ID: <37416118.11271189@netnews.worldnet.att.net>


On Thu, 29 Apr 1999 07:30:43 -0800, luc_san_at_hotmail.com (LUC San) wrote:

>Does anyone know how we can use GRANT in PL/SQL ?

Yes. You can't use GRANT directly from PL/SQL, but you can make use of the DBMS_SQL package. If I recall, that package is documented in the Application Developer's guide. If all you're doing is a grant, you won't find it difficult.

Jonathan Received on Fri Apr 30 1999 - 21:11:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US