Logon to Oracle

[BIS]

Hello,
I am trying to use a program that makes an ODBC connection to Oracle 8i. Whenever I do this I get a prompt: Logon to Oracle. How do I create a user to use this? Sorry if I am not specific enough, I am not quite sure what questions to ask...

 

[rtefft]

If you don't have an Oracle username/password, you can create one by logging into Oracle (SQL*Plus or ServerManager is easiest) and type something like this:

create user SMITH identified by FOO;
grant create session to SMITH;

This creates an account called SMITH with the password FOO.
There are many more options to the CREATE USER command in the SQL Reference Manual. You may also have to grant SMITH access to the database objects you want to reference (unless that user owns them). See the GRANT command in the same manual for info on that.

Heop this helps,
Rich
____________________________
Rich Tefft
PL/SQL Programmer

 

[BIS]

Many thanks! From the sqlplus I can login with sti/sti which I believe is standard. I probably need to grant permissions to sti for the specific tables. I will see what I can find on the GRANT command.