Explain how to create users through Sql Plus

          

Explain how to create users through Sql Plus.


Oracle - how to create users through Sql Plus posted by Babu Kunwar
<<Previous   Next>>

Explain how to create users through Sql Plus.

We need to first login to the data base as: SQLPLUS followed by user_name/password. Then we need to execute the following query:

CREATE USER user_name IDENTIFIED BY abcd; in this query a user_name suggest the user that is created which has a password abcd which is required for login in database.



Write your comment - Share Knowledge and Experience


<<Previous   Next >> 
More links
Oracle ODBC connectivity

What is ODBC? Explain its purposes
Difference between ODBC and Net8.
What do I need to get ODBC to work?
Explain how to create a Data Source.
Explain how to trace ODBC calls.
What is ODBC SQLPASSTHROUGH option?
How to attach an Oracle table in MS-Access?
Explain how to get Oracle data into MS-Excel........... .

Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring