remote access oracle database

quinnd6

Lets say a company has an oracle database of data.

This database exists on a server.

How would one go about remotely accessing this database?

Tom Dunne

quinnd6 wrote:

How would one go about remotely accessing this database?

That's a very open-ended question.

It depends on a lot of things. VPN springs to mind, but it would depend on how the server/network is configured.

Zambia

Java ODBC as long as you have the Connection details. And are on the Network

irlrobins

Assuming you have a PC that can currently access the DB through TOAD, SQL Plus, etc you could remote desktop connect to that PC and use it to access the DB.

Of course the underlying problem of whether the firewall will allow you to remote connect to ANY machine still exists.

quinnd6

Im trying to let someone else access the db.

Im now trying to create a new user in oracle who will only be able to view a certain number of tables.

I tried

create user username
identified by password;

I got this error

ERROR at line 2:
ORA-01031: insufficient privileges

Does that mean I havent assigned the right privelages to this user or does it mean I don't have privelages to create a user?

Beano

quinnd6 wrote:

Im trying to let someone else access the db.

Im now trying to create a new user in oracle who will only be able to view a certain number of tables.

I tried

create user username
identified by password;

I got this error

ERROR at line 2:
ORA-01031: insufficient privileges

Does that mean I havent assigned the right privelages to this user or does it mean I don't have privelages to create a user?

it means you dont have the privileges to create a new user (or whoever you were logged in as to be more precise)

Tom Dunne

quinnd6 wrote:

Im trying to let someone else access the db.

How? You said a remote database. How remote? Different company? Different country? Different PC?

quinnd6 wrote:

Does that mean I havent assigned the right privelages to this user or does it mean I don't have privelages to create a user?

It means you don't have privileges to create a user.

quinnd6

Theres an external company that needs to query the database Im using in the company I work for.

Im not accessing the database remotely myself.
I can connect to it locally.

I'm a programmer and I wasnt sure what rights I have.
So I dont have rights to create user accounts for the database as Im not an administrator.

thanks

Zambia

quinnd6 wrote:

Theres an external company that needs to query the database Im using in the company I work for.

Im not accessing the database remotely myself.
I can connect to it locally.

I'm a programmer and I wasnt sure what rights I have.
So I dont have rights to create user accounts for the database as Im not an administrator.

thanks

Well then first up your going to have to have your network configured to allow them to access the server that the DB is on.

Second Yes Creation of users is a right that normally only DBA's have so they have to set up your user and grant them the access rights you speak of. If the DB is yours well then you need to remember the sysadmin password I think there is a Oracle default of "changeme"

My option would be to create a View showing them the data they want an just giving them access to that.

BocArdee

When opening an SQL plus session try

"sqlplus connect / as sysdba". In most instances this should authenticate you as
the sysdba and your can create your user from there....

Hope this helps...

To connect remotely you can use terminal services to get onto your Oracle box,
if its windows, if its a unix box once you can connect to the local network you should be able to telnet/ssh to the box put this depends on a range of factors such as firewall ports, VPNs, Routing tables etc etc...