Maxmix
Member³
Hi,
I have discovered another nice thing:
Dragging User node from under "Granted to users" folder to the editor, and dropping it as DDL, we are getting something like this:
create user LOADERIRAO;
grant execute on WF_LOAD_IRAO to LOADERIRAO;
That is, we can recover the GRANT statement this way.
However, dragging Role node from under "Granted to roles" folder gives only
create role TANGIBLES_EXCHANGE_ROLE;
Can I have a grant statement generated for these cases too? Preferably with schema qualification(so that I could insert it in some script):
grant execute on tangibles.WF_LOAD_IRAO to TANGIBLES_EXCHANGE_ROLE;
I have discovered another nice thing:
Dragging User node from under "Granted to users" folder to the editor, and dropping it as DDL, we are getting something like this:
create user LOADERIRAO;
grant execute on WF_LOAD_IRAO to LOADERIRAO;
That is, we can recover the GRANT statement this way.
However, dragging Role node from under "Granted to roles" folder gives only
create role TANGIBLES_EXCHANGE_ROLE;
Can I have a grant statement generated for these cases too? Preferably with schema qualification(so that I could insert it in some script):
grant execute on tangibles.WF_LOAD_IRAO to TANGIBLES_EXCHANGE_ROLE;
