Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01045 (Oracle Database 10g Enterprise Edition Release 10.2.0.1.0, Windows XP Professional)
ORA-01045 [message #406677] Fri, 05 June 2009 06:10 Go to next message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
I am getting the following error:
ORA-01045: user ABC lacks CREATE SESSION privilege; logon denied ORA-02063: preceding line from ABC_LNK

I gave the create session grant to ABC but porblem still there.
Re: ORA-01045 [message #406682 is a reply to message #406677] Fri, 05 June 2009 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't give it the privilege into the correct database.

Regards
Michel
Re: ORA-01045 [message #406694 is a reply to message #406677] Fri, 05 June 2009 07:01 Go to previous messageGo to next message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
ok now error has changed:
ORA-00942: table or view does not exist ORA-02063: preceding line from ABC_LNK

Actually I am running the following query:
select *
from   abc.table_name@ABC_LNK;

This abc.table_name exist in another remote machine.
I also granted the access to the table abc.table_name to public but still getting the same error.
Re: ORA-01045 [message #406732 is a reply to message #406677] Fri, 05 June 2009 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
>This abc.table_name exist in another remote machine.
>I also granted the access to the table abc.table_name to public but still getting the same error.

Provide proof using sqlplus along with CUT & PASTE.
Oracle is too dumb to lie about errors.
You are doing something wrong or not doing all correctly.
Re: ORA-01045 [message #406737 is a reply to message #406677] Fri, 05 June 2009 10:03 Go to previous messageGo to next message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
while running the above query i m getting the error:
ERROR at line 2:
ORA-00942: table or view does not exist
ORA-02063: preceding line from CTC_LNK.WORLD
Re: ORA-01045 [message #406739 is a reply to message #406737] Fri, 05 June 2009 10:10 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

preceding line from ABC_LNK



Quote:

preceding line from CTC_LNK.WORLD



Either you do a lot of things you don't tell us about, or you fake the output.

Post EXACTLY what you granted in which database with EXACT copy/paste from SQL*Plus.

As it looks now, there are still grants missing in the CTC_LNK.WORLD database.

[Updated on: Fri, 05 June 2009 10:10]

Report message to a moderator

Re: ORA-01045 [message #406740 is a reply to message #406677] Fri, 05 June 2009 10:11 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
Nobody doubts that an error exists.

Before more assistance can be provided, you need to provide more details of exactly what you have & what you are doing.

We can only see what you post.

You have either an error of commission or error of omission,
but we can not tell which or why without additional details.
Re: ORA-01045 [message #406750 is a reply to message #406677] Fri, 05 June 2009 10:44 Go to previous messageGo to next message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
SQL> select *
  2  from   ctc.c_job_info@CTC_LNK.WORLD;
from   ctc.c_job_info@CTC_LNK.WORLD
           *
ERROR at line 2:
ORA-00942: table or view does not exist
ORA-02063: preceding line from CTC_LNK.WORLD
Re: ORA-01045 [message #406752 is a reply to message #406739] Fri, 05 June 2009 10:55 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
ThomasG wrote on Fri, 05 June 2009 17:10

Post EXACTLY what you granted in which database with EXACT copy/paste from SQL*Plus.

As it looks now, there are still grants missing in the CTC_LNK.WORLD database.


Or run the following in the CTC_LNK.WORLD database :

SELECT OWNER, TABLE_NAME, GRANTEE, PRIVILEGE 
  FROM DBA_TAB_PRIVS
 WHERE TABLE_NAME = 'C_JOB_INFO';


Also check which user is used in the dblink with :

SELECT * FROM DBA_DB_LINKS;



Re: ORA-01045 [message #407260 is a reply to message #406752] Tue, 09 June 2009 06:08 Go to previous message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
ok thanks the issue is resolved. There was a problem with the TNS
Previous Topic: Number to words ( using JSP giving error)
Next Topic: possible to partition exchange two tables
Goto Forum:
  


Current Time: Fri Dec 09 09:40:57 CST 2016

Total time taken to generate the page: 0.14055 seconds