-
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.
-
i have revoked the delte priviledge from the role but still i am able to delete a record from the front end.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|