Question about Veritas Cluster Server for Solaris Oracle 8i/9i Agent 4.0 (A09999F-A00000) for Sun

1 Answer

About sql*plus of oracle 8i

Please tell me the way to create username and password other than default on in a simple manner

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 58 Answers

Can you clarify your question?

For instance, where do you need to create the username/password? Oracle?

If you are asking for the sql to create a user in Oracle, it is very simple:
(change the items inside <> to your needs)
sql> create user <username> identified by <password>;

At this point, keep in mind that the user has no privileges, so the user will exist, but will not be able to do anything on the database.

Hint: What I like to do when I am in a hurry is create the user as follows:
grant <role> to <username> identified by <password>;

This command will create the user, assign it the password you gave it and grant the ability allowed by the role in question.

Hope this helps!

Posted on May 21, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

What is SQL?


It is a special purpose programing language. Computer language you will never use, unless you are into servers or programing type software

Jan 27, 2015 | Oracle 10g Database Standard (ODBSEONUPP0)

2 Answers

How to install oracle 8i in windows 7


Hi,

Oracle 8i is never intented to be used on Windows 7. Oracle will not support it. I think you have to look at virtualisation (Virtual Box, Virtual Pc, WMware), to get Oracle 8i installed on Win XP (or Win 2000/98).

Mar 11, 2010 | Computers & Internet

3 Answers

I want to install oracle 8i in windows 7, how i do this?


sir, i have a window7 in all in one hp but there is a software called mstar which run on oracle 8i when i install the oracle 8i there is a problem and show dll file corrupted. Pls tell me the solution because my client want it very urgently and i am not able to install and run the programm.

Feb 26, 2010 | Veritas Cluster Server for Solaris Oracle...

1 Answer

Access sql database using C.


Please go for the ORACLE 8i or higher, it has a utility called proC, in proC you can create program to access any database in Oracle or SQL server.

After compiling program in proC environment, it will create C code for tha same logic, that you can compile and use in C enviromnent

goodluck

Zulfikar

Mar 10, 2009 | Computers & Internet

1 Answer

I installed DB2 in my laptop . then i go to all programs->DBCOPY1(default)-> command line tools -> command editor then write down query to create a table but i cant build it it is showing CREATE TABLE...


Hi,

Before you create a table you need to:-

1. create a database
2. create a username and password or use the admin generated userid
3. connect to the database

you can then create a table and use the database

Please post if you do not know how to do this and i'll give you some links

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

ORacle 8i on Windows Vista


You wont be a ble to install Oracle 8i to Vista computer ,because that Oracle version is not supported on that Vista OS (only 10g onwards) will work with Vista computers.

Hope that helps........

Sep 12, 2008 | Computers & Internet

1 Answer

Oracle SQL Error


Does it connect after the error ?. First try to connect from your client to Oracle server using SQL plus client.

Second - Do a tnsping <server name>

This will give you the correct Host name, SID and Port number.

Make sure that your JDBC connection parameters match with the actual connection from TNS output

Sep 04, 2008 | Oracle 10g Database Standard (ODBSEONUPP0)

2 Answers

How to connevt visual basic with oracle(sql)


You need to install oracle client on client machine, and than you can use datasource (ODBC) to connect from vb to oracle.

Jan 23, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

315 people viewed this question

Ask a Question

Usually answered in minutes!

Top Veritas Computers & Internet Experts

Jax Planet
Jax Planet

Level 2 Expert

921 Answers

Mike

Level 3 Expert

4332 Answers

purushottam aher

Level 1 Expert

18 Answers

Are you a Veritas Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...