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.
14  1470 
To view the database in the server ,you need to login first to the server using
user name,password and connection string.
You can use the following code for selecting the name of the database to which you are connected. - select name from v$database;
but normal users don't have the previliges to select form the above mentioned table.
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
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.
You can also try: -
select instance_name from v$instance
-
It will give you the instance name you have logged in to. But again you might need privileges to run the above query!!
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.
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.
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 ?
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!!
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: lawrence |
last post by:
In the code below, the mysql_connect commands work correctly (though
I've changed the passwords here). I get the "We were able to
establish a connection" message. But then the code hangs and does
nothing. What am I doing wrong? The username and password are root, so
I should have the right permissions. The same username and password,
when I...
|
by: Lou |
last post by:
Please can someone put me out my misery!
Im trying to find a multiple user/password protection script that will
redirect the specific user to a specific directory.
At the moment I have set up htaccess which is fine but can only
protect one directory unless I put htaccess on each directory which I
think is a bit long winded, but is there any...
|
by: Kristen |
last post by:
Hi, I'm not sure if this can be done or not but here goes...
I write an application that uses Access and an MDW file to control who
can open the database. Right now I have a bunch of different customers
and we distribute the same MDW file to each customer. This MDW file has
one username/password in it that gives access to an Administrator to...
|
by: Oenone |
last post by:
Sorry for the cross-post but I've really no idea where this is best suited.
I've an ADO.NET application which connects to a SQL Server database. I have
spent the entire morning trying to get it to connect, but eventually got it
working by setting (in the web.config file) the authentication mode to
"Windows" and the identity impersonate flag...
|
by: John Salerno |
last post by:
Hi everyone. I just installed MySQL on my home PC and I tested out the
show databases query, and it lists two:
information_schema
bbdatabank
The second one is one I created myself, but I don't understand what the
first one is. It is not listed in my 'data' folder, but mysql and test
*are*, yet they aren't listed when I type the show...
| | |
by: Sridhar |
last post by:
HI,
I am having problems setting up a website so that it will be available
only inside the domain. We have three servers. One is iis server and second
one is internal server and the third one is sql server. I have deployed the
web application in the internal server. It is not able to access the sql
server that is on another server. If I...
|
by: Odd Bjørn Andersen |
last post by:
I have installed DB2 9 Enterprise Edition on my laptop and created the
sample database. Now I'm having truble connecting to the database from
Command Editor. If I connect from Command Window it's no problem connecting
to sample (or any other databases - local or remote), but if I try to
connect from Command Editor I'm not able to do that....
|
by: tom.youdan |
last post by:
Hi,
I have created a database that is used to store contact information for
NGO's accross India. It is simple in structure and I want a portion of
the data to be viewable on the Internet.
I want the information to be available for read access only.
What is the potential for using Data Access pages for this task and
what are the key...
|
by: runway27 |
last post by:
i am building a registration page where a user register for a username. i am able to insert this into mysql. the situation is every time data is inserted into example table1 in mysql in database1 for example at the same time i would like to extract the username, password and email from table1 based on the last inserted row and insert these values...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
