Re: limiting select acces to a table

From: Oracle <Lun>
Date: 1996/11/06
Message-ID: <55p8q2$31i_at_news.hk.gin.net>#1/1


mike west wrote:
>
> Is it possible to limit select access to certain columns in a table
> using the grant command or is a view the only way to do this ????

  You can try to use GRANT SELECT(column_name ...) ON table_name TO username

  Related Topics: Privilege, Profile

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response 
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841
Received on Wed Nov 06 1996 - 00:00:00 CET

Original text of this message