OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » ora-00022

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

ora-00022 [message #201172]

Thu, 02 November 2006 20:21

cavinlam83
Messages: 24
Registered: August 2006
Location: MALAYSIA

Junior Member

ORA-00022: invalid session ID; access denied
Cause: Either the session specified does not exist or the
caller does not have the privilege to access it.
Action: Specify a valid session ID that you have privilege
to access, that is either you own it or you have the
CHANGE_USER privilege.

I got this error message when i start to do transaction with oracle 10g in my c# application. I want to grant CHANGE_USER priviledge, but i can't find that priviledge in Oracle 10g. Any other solution for that? Can anyone help me? Thanks...

Report message to a moderator

Re: ora-00022 [message #201287 is a reply to message #201172]

Fri, 03 November 2006 07:00

amul
Messages: 252
Registered: April 2001
Location: Chennai

Senior Member

only if you are a DBA you will be able to grant privileges.

Report message to a moderator

Re: ora-00022 [message #201583 is a reply to message #201172]

Sun, 05 November 2006 23:30

cavinlam83
Messages: 24
Registered: August 2006
Location: MALAYSIA

Junior Member

But the problem is i can't find the priviledge in oracle 9i and oracle 10g, how im going to grant this role (CHANGE_USER priviledge) even i log in as DBA?

Report message to a moderator

Re: ora-00022 [message #201590 is a reply to message #201583]

Sun, 05 November 2006 23:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

I don't think here "change_user" privs in oracle.
"change_user" privs ?

[Updated on: Sun, 05 November 2006 23:57]

Report message to a moderator

Re: ora-00022 [message #201592 is a reply to message #201172]

Mon, 06 November 2006 00:15

cavinlam83
Messages: 24
Registered: August 2006
Location: MALAYSIA

Junior Member

----------------------------------------------------------
ORA-00022: invalid session ID; access denied

Cause: Either the session specified does not exist or the caller does not have the privilege to access it.

Action: Specify a valid session ID that you have privilege to access, that is either you own it or you have the CHANGE_USER privilege.

-------------------------------------------------------------

Any idea to solve this error? Thanks...

Report message to a moderator

Re: ora-00022 [message #201600 is a reply to message #201592]

Mon, 06 November 2006 00:46

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi
i was already check above error in documentation.
but i am not able to find solution.

sorry
wait somebady expert in forms they will definately solve ur problem.

Report message to a moderator

Re: ora-00022 [message #201624 is a reply to message #201600]

Mon, 06 November 2006 02:26

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Metalink has bug 4886455 related to this issue.

In summary, forget about the CHANGE_USER privilege - you can't use it.

Report message to a moderator

Previous Topic:	PL/SQL Function
Next Topic:	how to GRANT, is it possible???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 14 09:00:44 CDT 2026