Re: row level security. How do I do it?

mdlcpgs_at_lhn.gns.cri.nz.nospam wrote in article <6e7dg1$qi4$1_at_wnnews1.netlink.net.nz>...
> An approach that appeals more is a view like
> CREATE VIEW crippled as SELECT * FROM myTABLE where status = 1;
>
> The problem is, how do I let them open this view without also giving them
> select rights to the underlying table?

select access on a view does not give select access on the underlying table. f'rinstance, you can select from user_objects, but that doesn't give you permission to select from sys.obj$. this is one of the main reasons for using views.

-- 
Andrew - Wizzard

barnetaj_at_bp.com