Create User

Creating new user
Syn:-   CREATE USER username IDENTIFIED BY password;
            GRANT CONNECT, RESOURCE TO username;
Ex:-     step1: connect system;
                   2:password : manager
                   3: create user vision identified by prasad;
                   4: grant connect, resource to vision;
                   5: connect vision
                        password: Prasad

DROP USER
             A user can be dropped by DBA by using the following statement
Syn:-   drop user username cascade;
Ex:-      drop user suri cascade;

For
Online Classes

Contact Us: +919885348743