Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    7

    Unanswered: restricting user

    I have report running in oracle developer. I want to create a users xyz and want to restrict that user to see the same report except those rows which have say 'computer' in its DESCRIPTION column.
    my table is
    ITEM( item_no, description, detail, price)
    Thanks for replying earlier

  2. #2
    Join Date
    Mar 2009
    Posts
    7

    restricitnig user to see schema

    I want to restrict my users to not not see schema how I can do this.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Check out Oracle's virtual private database:

    http://www.devshed.com/c/a/Oracle/RowLevel-Security-with-Virtual-Private-Database/

    http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/apdvpoli.htm#CHDFGBEB

Posting Permissions

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