Re: Stored procs for adding, dropping, granting, revoking

>Does anyone know how to get a stored procedure to
>accept a drop user, grant, and revoke.

You need to use dynamic SQL, which you can do by using the routines in the DBMS_SQL package described in the Application Developer's Guide.

Grants and revokes aren't too bad. All you have to do is call SQL_PARSE on the statement in order to execute it. Received on Sat Jan 03 1998 - 00:00:00 CST