| ORA-01045 [message #406677] |
Fri, 05 June 2009 06:10  |
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 #406694 is a reply to message #406677] |
Fri, 05 June 2009 07:01  |
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 #406737 is a reply to message #406677] |
Fri, 05 June 2009 10:03 |
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 |
ThomasG
Messages: 3212
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 #406750 is a reply to message #406677] |
Fri, 05 June 2009 10:44 |
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 |
ThomasG
Messages: 3212
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;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
