DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: menu security in forms

  1. #1
    Join Date
    May 2000
    Location
    ahmedabad,gujarat,india
    Posts
    14

    Post

    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

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    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.

  3. #3
    Join Date
    May 2000
    Location
    ahmedabad,gujarat,india
    Posts
    14

    Arrow

    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
  •  


Click Here to Expand Forum to Full Width