Stored procedures and privileges

Is there a way to have a stored procedure run with other(more powerfull) privileges, than the user that executes the procedure?

What i want is a procedure that creates and drop users and grants and revoke access to tables. This procedure should be executed by a user that does not own nor have been granted accces with grant option, also the user executing the procedure has not been granted create user.

Thanks
Peter Received on Thu Apr 15 1999 - 05:26:10 CDT