Column level security

From: ray (raywagoner@aristotle.net)
Date: 07/27/02 

From: "ray" <raywagoner@aristotle.net>
Date: Sat, 27 Jul 2002 08:57:41 -0700

 Have assigned select perm to a table and deny perm to a
column within that table. Made query that included denied
column. When admin ran query, got all columns. When less
important group ran query got no columns at all. Want to
get less important group to get everything except denied
column without modifing query.

Result wanted for admin:
      john 000-00-0000 manager 555-1212

Result wanted for others:
      john #name manager 555-1212

Relevant Pages