Answer / ayan banerjee

create user user_name identified by password

then

grant resource to user_name

grant create session to user_name

Answer / guruswamy

create user <username> IDENTIFIED BY password;

Answer / satyajit patel

If u later want to change the password then go to the
database where the user is created and write

ALTER USER user_name IDENTIFIED BY new_password;

How to change sql*plus system settings?

0 Answers  

---

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

---

What is java sql driver?

0 Answers  

---

What is full join?

0 Answers  

---

How many functions are there in sql?

0 Answers  

---

What is the purpose of design view?

0 Answers  

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

how can we repair a mysql table? : Sql dba

0 Answers  

---

How do I view an execution plan in sql?

0 Answers  

---

Define the select into statement.

0 Answers  

---

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

---