Granting roles from stored procedure

From: Heather van der Zweep <hvanderz_at_ch2m.com>
Date: 1997/02/27
Message-ID: <01bc24d9$c8a6a980$7a054d82@hvanderz.ch2m.com>#1/1

Anyone know if it's possible to execute a grant role command from within a stored procedure? I have tried using dbms_sql.parse to issue the command but am getting an invalid privilege error. I am able to grant the role from the sql prompt.

Can I assume that grant/revoke is illegal from within a stored procedure?

If you have a solution, please e-mail me at hvanderz_at_ch2m.com as well as posting to this newsgroup. Our news server has been acting up.

Thanks in advance.

Heather van der Zweep
CH2M HILL Inc Received on Thu Feb 27 1997 - 00:00:00 CST