Try dbms_rls.
Here you define row level access.

rgds
amar

-----Original Message-----
From: Lazar Tomovski [mailto:[Email Address Removed] Friday, June 29, 2001 1:44 PM
To: LazyDBA.com Discussion
Subject: security problem



Ok so there is my problem..
I want that some users cannot see all of the rows of a table what should I
do
a view???


_________________________________________________
IncrediMail - Email has finally evolved -
<http://www.incredimail.com/imstampa.html> Click Here

Oracle LazyDBA home page