RE: restrict access to certain columns only

Check SQL Reference at 'GRANT'.
End of a difficult week ? :-)

SF

>----- ------- Original Message ------- -----
>From: "Daiminger, Helmut"
><Helmut.Daiminger_at_KirchGruppe.de>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Fri, 11 Apr 2003 06:37:18
>
>Hi!
>
>What would be the best way to restrict users'
>access to certain columns of a
>table?
>
>e.g. User1 owns a table and want to grant user2 the
>right to update only
>certain columns in that table. What would be the
>best way to implement this?
>
>Using a view and granting user2 update rights on
>the view?
>
>
>This is 9.2 on Solaris.
>
>Thanks,
>Helmut

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).