using exp to back up the db schema
ngac_rMay 17 2010 — edited May 18 2010We have a forms/reports based system.
We use "exp" each night to export the schema and all data as back up.
There is only one db user and all tables/packages/procedures/functions are within that one db user which is set to SYSDBA access.
The end user never knows the user password as they access via forms.
Here is our problem.
We use another user "exp_user" to do the export of the above schema.
we use
grant EXP_FULL_DATABASE to exp_user with admin option;
this exp_user is for exporting the db and also the users can use this to odbc into the db for view only.
Our problem is that exp_user can run queries on the packages/procedures. Is there any way to prevent this action being allowed but still allowin export of all as they can potentially do damage by using the packages?
Thanks