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;

what is global variable in pl/sql

1 Answers  

---

Is null operator in sql?

0 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

What is the difference between rename and alias?

0 Answers  

---

What is having clause in sql?

0 Answers  

---

Can a foreign key have a different name?

0 Answers  

---

What does (*) mean in sql?

0 Answers  

---

What are the data types allowed in a table?

3 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

How do I run a script in sql developer?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is server name sql?

0 Answers  

---