OraFAQ Forum: Text & interMedia » Oracle Context

Home » Server Options » Text & interMedia » Oracle Context - Solution

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Context - Solution [message #73765]

Tue, 06 July 2004 05:54

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.
-

Report message to a moderator

Re: Oracle Context - Solution [message #73766 is a reply to message #73765]

Tue, 06 July 2004 13:47

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: Oracle Context - Solution [message #73767 is a reply to message #73765]

Tue, 06 July 2004 20:38

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 02:54:36 CST 2024