|
|
|
|
|
|
|
|
| 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 #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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
