Am designing a visualC++ application that has to access relational
tables. Different kind of users will have to use the application at
various levels. Is it possible that i can grant users access to my
tables but restrict them from accessing some particular rows of the
table? Some rows will store data that some users don't need to be
aware of. I know how to restrict access to columns.
Maybe my design is f***edup. Designing my aplliction will be easier
if I can restrict access to rows. It will immensely reduce the
amount of effort I have to put into the app.
Is it possible to restrict user access to rows in an oracle database?