Hi,

How can I use grant in stored procedure ?
How can I know that something like "execute statement 'grant execute on
procedure USUN_DOK to TEST'" failed ?
I want to throw exception when there is no privilege with grant option for
current user but maybe grant tend to generate exeception by itself when
there is no privilege with grant option for current user (which executes
procedure)?

What i'm trying to do (I know is something unusual) is to pack a few (or
more) grant commands (mostly execute privileges to some stored procedures
working together) into one procedure to easly rollback all and to avoid
processing them in user applications differently.

Thanks for any help.

--
Best Regards
Bogusław Brandys