| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie: How to prevent a commit
> I am using java (JDBC) to query and update an oracle database. I would
> like to revoke myself the privilege, or denying myself the possibility
> of executing the sql statements COMMIT or UPDATE.
>
> If is sounds a bit strange, the reason why I want to do that, is
> testing. I want to make sure that I am handling exceptions in my
> program. If for any reason the user cannot commit, I want to make sure
> that the exception is handled.
>
> The problem that I have is that I cannot revoke/grant privileges to
> myself. Moreover, the database is located in an account which belongs to
> me. My program is accessing the database, using my username and
> password. I cannot access it using someone else's password. Therefore, I
> don't really know how to handle this.
Why don't you set up a test user? Revoke/grant privileges to the test user and test your application that way. If you application is coded in such a way that you can't change the userid/password, how about moving the tables to a the test user, creating synonyms, and granting to your userid? It's a long way to go, but it can be done.
HTH,
Brian
--
 |
 |