Recent content by dragot

But I need the user of schema B not to see all rows and also to have privileges just to some of them and not to the whole table T. That's why I have to use view (or do you see any other possibility?). I still do not understand why it works when I use the SQL statement and using OracleDataSet...

Sorry for my bad english. I have some trouble. Situation: I have two schemas A and B. In schema A I have table T and in this table is clob field. Schema B doesn't have any right to the A.T . Then I create view V on table T and grant all privileges on view V to schema B. And then when I try to...