OraFAQ Forum: Server Administration » DB

Home » RDBMS Server » Server Administration » DB_LINKS uses user account (Oracle 10.2.0.2.0,Unix)

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

DB_LINKS uses user account [message #510516]

Mon, 06 June 2011 06:01

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

How to find out list of DB_LINKS that uses user account in database ??

Thanks

Report message to a moderator

Re: DB_LINKS uses user account [message #510520 is a reply to message #510516]

Mon, 06 June 2011 06:21

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

select table_name from dict where lower(comments) like '%database link%';

Regards
Michel

Report message to a moderator

Re: DB_LINKS uses user account [message #510524 is a reply to message #510520]

Mon, 06 June 2011 06:48

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

i executed the query and it returned 2 rows.Is this query for a particular user
say 'BALA' ?

say for example i want to find out the db links that uses BALA account.

Thanks

Report message to a moderator

Re: DB_LINKS uses user account [message #510525 is a reply to message #510524]

Mon, 06 June 2011 06:49

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't see what you executed.

Regards
Michel

Report message to a moderator

Re: DB_LINKS uses user account [message #510632 is a reply to message #510524]

Mon, 06 June 2011 21:32

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

>say for example i want to find out the db links that uses BALA account

Do you mean : "I want to the list of Database Links in my [currently connected to] database that use the account BALA to connect to 1 or more remote databases" ?

In that case, couldn't you query DBA_DB_LINKS thus :

select OWNER, DB_LINK, HOST where USERNAME='BALA'   ?

Hemant K Chitale

Edit:
Mod-code tags

[Updated on: Tue, 07 June 2011 00:01] by Moderator

Report message to a moderator

Re: DB_LINKS uses user account [message #510643 is a reply to message #510632]

Tue, 07 June 2011 00:50

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SQL> select OWNER, DB_LINK, HOST where USERNAME='BALA'   ;
select OWNER, DB_LINK, HOST where USERNAME='BALA'
                            *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

Something wrong in the query.

Regards
Michel

Report message to a moderator

Re: DB_LINKS uses user account [message #510659 is a reply to message #510643]

Tue, 07 June 2011 03:13

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

Ah yes. My mistake.

I think that the query should have been :

select OWNER, DB_LINK, HOST 
from DBA_DB_LINKS 
where USERNAME='BALA'
/

Hemant K Chitale

PS : I am surprised that with all the superior knowledge that you have, you weren't able to correct my error. I do hope that you will be able to help others and correct any errors they might make.

CM: fixed code tags. They're [code] and [/code] not {code}

[Updated on: Tue, 07 June 2011 03:28] by Moderator

Report message to a moderator

Re: DB_LINKS uses user account [message #510667 is a reply to message #510659]

Tue, 07 June 2011 03:45

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

PS : I am surprised that with all the superior knowledge that you have, you weren't able to correct my error. I do hope that you will be able to help others and correct any errors they might make.

I am able to correct it, what I wanted to point you to is that you MUST verify your query before posting it (and given the level of some readers there is some likelyhood they will not be able to correct it by themselves).

Regards
Michel

Report message to a moderator

Re: DB_LINKS uses user account [message #510758 is a reply to message #510667]

Tue, 07 June 2011 10:03

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

>you MUST verify your query before posting it

True. I did make a mistake there.

Hemant K Chitale

Report message to a moderator

Re: DB_LINKS uses user account [message #514297 is a reply to message #510758]

Sun, 03 July 2011 13:19

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Thank you all..

Report message to a moderator

Previous Topic:	kkjcre1p: unable to spawn jobq slave process
Next Topic:	Granted privileges but not able to see in DBA_SYS_PRIVS table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 21:59:37 CDT 2024