I know that it's possible to grant public permission to UNLOAD via the -gl database option. I don't really want to do that. Is it possible to create a procedure that puts a wrapper around my specific UNLOAD statement and then grant a specific user permission to execute that procedure? (I'm trying, but its not working, and I'm not getting any meaninful error messages). Thanks! I'm using 9.0.2.3850 |
You can do this by creating a procedure owned by DBA and then grant execute permissions to the user that you want to be able to run this procedure. Example:
This gives the user |