Re: GRANT <priv.> ON <tabName> *<WHERE-clause>* TO <username>...

Which version of Oracle does it not work for ? I haven't had any problems with the actual SET_CONTEXT procedure.

Apologies if this is insulting - but are you aware that when you create a context you specify the single package that will be allowed to change the context. Consequently the directive to

'use dbms_session inside a procedure'

should be read as

'use dbms_session inside a procedure in the package you specified as the package that is allowed to set the context',

and not as

'use dbms_session inside any old procedure that you happen to write'.

(I have had problems with contexts in 8.1.5, but that was with parallel queries trying to use the sys_context values)

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



monsri_at_my-deja.com wrote in message <91v304$phg$1_at_nnrp1.deja.com>...


>you would understand... And don't forget the DBMS_SESSION.SET_CONTEXT

>procedure doesn't work (check the doc. ID 100130.1 on Metalink: the

>would-be workaround they give -embed the SET_CONTEXT command line

>inside a user-defined procedure- doesn't work neither).

>