Dbms_session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Dbms_session

  1. #1
    Join Date
    Aug 2004
    Location
    new jersey
    Posts
    6

    Dbms_session

    When I am trying to execute DBMS_SESSION.SET_CONTEXT, I am getting no privilege to execute SYS.DBMS_SESSION.SET_CONTEXT. I don't have access to SYS account. Is there a way to get around this by like asking the DBA to give some grant for me to execute etc.

    Thanks,
    PN

  2. #2
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    A context can only be accessed via a trusted procedure. This proc is specified when the context is created. E.g.

    Define proc SetMContext. It serves as the trusted procediure for the context. Only it is allowed to call dbms_session.set_context to set name-values in M_CONTEXT.

    Then you issue the following to create the context and bind its trusted procedure to it:
    create or replace context m_context using SetMContext;
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    I've got a couple of examples of using contexts here:

    http://www.oracle-base.com/articles/...ngContexts.php
    http://www.oracle-base.com/articles/...ts.php#context

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width