Re: Granting SELECT on specific COLS. How?
From: Kim Ng <kimmng_at_eskimo.com>
Date: Tue, 3 Jan 1995 03:00:47 GMT
Message-ID: <D1t71C.8z0_at_eskimo.com>
Mr. Kim Ng (President)
Paradigm Computer Consulting, Inc.
20611 E. Bothell Everett Hwy. S.E., Suite 280 Bothell, WA 98012
e-mail: kimmng_at_eskimo.com Received on Tue Jan 03 1995 - 04:00:47 CET
Date: Tue, 3 Jan 1995 03:00:47 GMT
Message-ID: <D1t71C.8z0_at_eskimo.com>
Unless there is something I miss, you will have to create a view with only those columns that you want others to see and grant access to that view. Since it is a single table view, you can still do insert, update, delete from that view. For more detail read the ORACLE documentation (I don't remember which one)
Have fun.
Mr. Kim Ng (President)
Paradigm Computer Consulting, Inc.
20611 E. Bothell Everett Hwy. S.E., Suite 280 Bothell, WA 98012
e-mail: kimmng_at_eskimo.com Received on Tue Jan 03 1995 - 04:00:47 CET