Re: column masking in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 01 Mar 2007 09:34:46 -0500
Message-ID: <BAY101-F35E53601FDEA605394436FEF800@phx.gbl>

Alexander and Chris,

Thanks very much for your quick response to share your code with me. What I'm looking for is the code that does not involve the row level security. Here is the example.

SQL> create table col_masking
2 (
3 n number,
4 data varchar2(100)
5 );

Table created.

SQL> insert into col_masking
2 select level, to_char(level)
3 from dual
4 connect by level <= 10;

10 rows created.

SQL> commit;

Commit complete.

SQL> select * from col_masking;

/* for users that have privilege to see the column data*/

        N DATA
---------- -----

        1 1
        2 2
        3 3
        4 4
        5 5
        6 6
        7 7
        8 8
        9 9
       10 10

10 rows selected.

/* for users that don't have privilege to see the column data*/

        N DATA
---------- -----

        1
        2
        3
        4
        5
        6
        7
        8
        9
       10

10 rows selected.

Dave

---

Play Flexicon: the crossword game that feeds your brain. PLAY now for FREE.    http://zone.msn.com/en/flexicon/default.htm?icid=flexicon_hmtagline

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 01 2007 - 08:34:46 CST