Totally Hidden Column - Analogous to OLS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Totally Hidden Column - Analogous to OLS

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

    Totally Hidden Column - Analogous to OLS

    Does anyone know of a way to totally hide a column? I mean totally hidden - ie. it does not show up in 'describe' 'or select * from...'

    Now, the best Oracle analogy of this hidden column concept is in Oracle Label Security. The hidden label column does not show up anywhere unless you explicitely select it.

    The reason for this is we have much legacy code in older types of programming languages that we do not want to modify and recompile. One idea i have is to create an OLS policy for the table (freakin' ugly idea because my intention has nothing to do with OLS - but it would work).

    Your advise is very appreciated.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Lightbulb

    Create a view and grant access to the table through this view only.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    Thinking through your idea i dont think it will work because:

    A scott.table123 table and a scott.table123 view cannot exist in the same schema. Remember, I don't want to edit and recompile all the code.

    Thanks.

  4. #4
    Join Date
    Jun 2000
    Posts
    417
    Couldn't you create a schema with the name that all the code is expecting, and make that schema contain only views with the same name as the tables? Then put all the real tables in another schema?

    FYI, Apparently OLS in 10g will have column level security, but obviously that doesn't help you now.

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Lightbulb

    Or you could rename the tables:

    conn scott/tiger
    RENAME table123 to table123_base
    Create view table123 as
    select ... from table123_base;
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    would the virtual private database functionality be of some help?

    http://download-west.oracle.com/docs...te.htm#1012507

    steve
    I'm stmontgo and I approve of this message

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by stmontgo
    would the virtual private database functionality be of some help?
    I don't think so. He want's to "hide" particular columns (vertical partitioning), while VPD enables you to "hide" particular rows (horizontal partitioning).

    Using views is the way to go for his requirements.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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