Re: Granting SELECT on specific COLS. How?
From: Alvin Law <alaw_at_oracle.com>
Date: 4 Jan 95 01:48:38
Message-ID: <ALAW.95Jan4014838_at_ap226sun.oracle.com>
Date: 4 Jan 95 01:48:38
Message-ID: <ALAW.95Jan4014838_at_ap226sun.oracle.com>
In article <1995Jan3.101803.1_at_v9001.ntu.ac.sg> se7107297_at_v9001.ntu.ac.sg (Juan Ho) writes:
> I want to create a table which allows everyone to see SOME columns
> only, and the rest are private to me. How would I go about doing this?
>
> I am using Vax Oracle 6.
Using a view is the only workaround. You can either select the appropriate columns in the view, or create a generic view with decode columns to NULL out any inappropriate columns.
-- ___ (o o) +-oo0-\_/-0oo---------------------------------------------------------------+ | Alvin Law .. Project Leader, Applications Division ... Oracle Corporation | | Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299 | +---------------------------------------------------------------------------+ ORA-03113: end-of-file on communication channelReceived on Wed Jan 04 1995 - 01:48:38 CET