Re: Granting roles from stored procedure

Chris Halioris wrote:
>
> Actually the stored procedure runs with the privileges of the user that
> created the procedure. Hence, if the account you compiled the procedure
> in does not have the privilege to issue the grant you are issuing, that
> would be your problem.

Try Granting the Create Role to PROC_OWNER WITH ADMIN

Sunil

-- 
"If you want what you've never had, 
 you must be willing to do what you've never done."