Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: Restricting Access, best approach?

    One of our business rules restricts updates on 3 fields in a table for one type of user, and 5 fields in that same table to another type of user. I could use 2 views to implement these restrictions, but is there another approach? I'd like to create a single Oracle Form for all users, and avoid the complexity of conditionally using one of many views during UPDATE.

    With object privileges, is there a way to restrict UPDATE/INSERT/DELETE on particular columns in a table, while not restricting other columns, without the use of views?


  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1
    You can do this:

    grant insert (empno, ename), update (ename) on emp to some_role;

    Of course, DELETE is all or nothing!
    Last edited by andrewst; 05-10-04 at 13:09.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts