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 asked 09 Apr '10, 20:52 Ron Hiner |
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 answered 09 Apr '10, 22:57 Mark Culp |