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
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-5841Received on Wed Nov 06 1996 - 00:00:00 CET