Stored procs for adding, dropping, granting, revoking

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

If you try these directly there is an error saying that it is illegal and the documentation backs this up, but is there a work around or something.

I had looked at SQL_STANDARD and it had one promising routine in it, but it did not seem to work.

Any other ideas?

Thanks

Bert Nelson
nelsonb_at_mail.vii.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet