Home » Server Options » Text & interMedia » Oracle Context - Solution
Oracle Context - Solution [message #73765] Tue, 06 July 2004 05:54 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
-

Hi,

Anybody can give me a solution for the following. I'm having following tables -

Table_1
======
Region
Sales

Table_2
======
User_name
Region

Whenever a user fires a query like "Select * from Table_1" it has to return the rows which belong to his region only.

I came to know that it is possibe throgh setting CONTEXT. can anybody give me some information regarding this.

Regards,
Ronald.
-
Re: Oracle Context - Solution [message #73766 is a reply to message #73765] Tue, 06 July 2004 13:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please have a look here
http://www.hk8.org/old_web/oracle/guide8i/ch08_05.htm
Re: Oracle Context - Solution [message #73767 is a reply to message #73765] Tue, 06 July 2004 20:38 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

If u r using oracle 9i than u can do it simply by using LABEL SECURITY feature. For more info refer to

http://otn.oracle.com/deploy/security/ols/index.html

Daljit Singh
Previous Topic: How to obtain key words from the text?
Next Topic: connect 2 databases(fetch from one, insert into other) - ProC++ sample code
Goto Forum:
  


Current Time: Thu Mar 28 18:09:06 CDT 2024