Having problems with message search?
I would say...
Use a Stored Procedure on the Server to request particular queries of data - that way you can restrict the flow of information server side and the end-user wouldn't know any better. By sending variables to the Procedure you can dynamically change what data you are returing as an end result.
----- Original Message -----From: codeforever2003Sent: Tuesday, June 01, 2004 1:08 PMSubject: [oo4ole] Can an administrator restrict user access to rows in oracle9!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?
===================================================================
To post a message, send email to: oo4ole@yahoogroups.com
To subscribe, send an email to: oo4ole-subscribe@yahoogroups.com
To unsubscribe, send an email to: oo4ole-unsubscribe@yahoogroups.com
To contact the list owner, send an email to: oo4ole-owner@yahoogroups.com
To view Yahoo! Groups info about this newsgroup: http://groups.yahoo.com/group/oo4ole
===================================================================
Offline 
Send Email