Re: Granting SELECT on specific COLS. How?
From: Jonathan Lewis <Jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 6 Jan 1995 19:37:03 +0000
Message-ID: <789421023snz_at_jlcomp.demon.co.uk>
Date: Fri, 6 Jan 1995 19:37:03 +0000
Message-ID: <789421023snz_at_jlcomp.demon.co.uk>
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.
:
: Help appreciated,
: Juan Ho
:
:
How about:
grant select (col1, col2, col3) on table1 to public;
-- Jonathan LewisReceived on Fri Jan 06 1995 - 20:37:03 CET