i have created a role in user scott which has been granted insert and select o table privilege.but when irun the form as scott user i am able to delete the record. what privileges have i to revoke from user scott or whether i ahve to create a new user with certain privileges?
what to do and how to do
SCOTT is not the owner of the table?
In ALL_TAB_PRIVS_RECD you can find the table priviliges granted to SCOTTor PUBLIC. Maybe he or PUBLIC has a delete privilege for the table.
Or he has a role with that privilege, select ROLE_TAB_PRIVS.