Viewing available databases with password and username

[kmpathy]

I am new Sql Plus

Want to know the command for viewing databases avaialble using default password and username on my co. server.. (example : dir command for viewing files) help me.

[debasisdas]

To view the database in the server ,you need to login first to the server using
user name,password and connection string.

[debasisdas]

You can use the following code for selecting the name of the database to which you are connected.

[CODE=oracle] select name from v$database;[/CODE]
but normal users don't have the previliges to select form the above mentioned table.

[kmpathy]

Thanks for your reply,

but it says

SELECT name FROM v$database
*
ERROR at line 1:
ORA-00942: table or view does not exist

what to do ?

actually i used the scott/tiger and connected ? is this correct

[debasisdas]

but normal users don't have the previliges to select form the above mentioned table.

I have already told you that.

ask your DBA to grant you the required priviliges.

[amitpatel66]

You can also try:

[code=oracle]
select instance_name from v$instance
[/code]

It will give you the instance name you have logged in to. But again you might need privileges to run the above query!!

[kmpathy]

Sir,

My DBA is not helping me, trying to hide everything... because i am new comer to the company... i am skilled in hardware and accounts as well as implementing/installing (i installed oracle for my own to my machine) and trouble shooting software. thorogh knowledge in erp modules.. i capture erp password. now want to do backend work through sql plus.

i find the server name and user name, but i dont know the password... how to bye pass it.. help me.

now i am connecting through scott/tiger as user name and password to my server.. it also connecting to the server after that it shows one file name called login if i use desc command it show the all fields, but not showing my related databases...

i find the user name called "system" but unable to find the password... how can i achieve any possibilities are there? help to climb me up. if i get the password i along climb myself.. show me the way please.

[debasisdas]

Sir,

My DBA is not helping me, trying to hide everything... because i am new comer to the company... i am skilled in hardware and accounts as well as implementing/installing (i installed oracle for my own to my machine) and trouble shooting software. thorogh knowledge in erp modules.. i capture erp password. now want to do backend work through sql plus.

i find the server name and user name, but i dont know the password... how to bye pass it.. help me.

now i am connecting through scott/tiger as user name and password to my server.. it also connecting to the server after that it shows one file name called login if i use desc command it show the all fields, but not showing my related databases...

i find the user name called "system" but unable to find the password... how can i achieve any possibilities are there? help to climb me up. if i get the password i along climb myself.. show me the way please.

Don't try to access anything for which you don't have permission.

It seems you are trying to hack somthing .

I am really sorry i can't help you in this case.

This is strictly against forum Rules.

[kmpathy]

Sir,

You are mistaken it seems.. challenging the newcomers like me ends to find the help of forum... i never tried to hatch anything.. somebody (juniors) whose is senior level playing as selffish... i dont know how to make u trust on me.. anyway thanks for your comments.

Even i had my superior (CFO) letter regarding this with me as a proof... how can i send u ?

[amitpatel66]

Sir,

You are mistaken it seems.. challenging the newcomers like me ends to find the help of forum... i never tried to hatch anything.. somebody (juniors) whose is senior level playing as selffish... i dont know how to make u trust on me.. anyway thanks for your comments.

Even i had my superior (CFO) letter regarding this with me as a proof... i can i send u

Hi,

In case if you really need access to some database instances/data dictionary views, then you can of course raise a request with your higher level managers who would help you getting the access rights/privileges.

No company will ask you to work without giving you privileges if it is worth to be given and is a part of your requirement!!

[amitpatel66]

Sir,

Even i had my superior (CFO) letter regarding this with me as a proof... how can i send u ?

Do you mean your supervisor have given you rights to hack the password of the database in any way by hook or cook??

[kmpathy]

You are correct. Even i have authorisation letter.. the fellow sitting above is the only person and treating himself as a monopoly.. and not interested to share is level.. thanks anyway i will sort it out with my superiors and get the privileges and come to forum for help. thank you.. definitely i will be back...

[kmpathy]

Do you mean your supervisor have given you rights to hack the password of the database in any way by hook or cook??

again mistaken.. i got authorise to share the works of DBA.. since it is a group of companies.. that fellow is from other entity from the group holding uppper hands.. even top officials not aware of erp and sqls.. day to day work going as usual..

[amitpatel66]

You are correct. Even i have authorisation letter.. the fellow sitting above is the only person and treating himself as a monopoly.. and not interested to share is level.. thanks anyway i will sort it out with my superiors and get the privileges and come to forum for help. thank you.. definitely i will be back...

You are always welcome to TSDN with any kind of technical issues. We will help you out!!

Thanks!!

[kmpathy]

You are always welcome to TSDN with any kind of technical issues. We will help you out!!

Thanks!!

Even my company is searching for good free lance oracle person to alter the program and to train peoples...

if u have any idea to suggest mail me mail id removed
Thanks!! and warm regards,
kmpathy