Re: oracle hidden columns?

FGAC (fine-grained access-control) can use "hidden" colums on tables, although I doubt very much this is relevant in this case...

ETA postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0305122333.7017e023_at_posting.google.com>...
> stephenvong_at_yahoo.com (stephen) wrote in message news:<a37c624a.0305091141.40b3944b_at_posting.google.com>...
> > Hi,
> >
> > I was going to create a new field on all my tables to support
> > multiple-column context searches, but my manager doesn't want me to
> > create a new field on all the table because it will affect everyone
> > else who is using our database. I was inform that Oracle have hidden
> > fields on every table? They created these hidden fields for OLS? I
> > am not using OLS and I would like to know what are these hidden
> > fields. I would like to use these hidden fields if I can, instead of
> > creating a new field. The only field that I know of is irow. If you
> > know the answer, please send your reply to stephenvong_at_yahoo.com
> >
> > Thanks,
> > Stephen
>
> Oracle doesn't have 'hidden' columns, and your manager should better
> go back the school. One of the main features of a RDBMS is that an
> ALTER TABLE doesn't affect other users AT ALL (unless you use views
> like select * from table, which Oracle advises expressly against)
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu May 15 2003 - 13:20:55 CEST