How To Connect With Oracle Database | Create Your Own User In Oracle Database
How to work with Oracle database a guide from beginner to advance. In this article, we will look at all the concepts which are useful to work with the oracle database. Steps to follow work with Oracle Database: Install the Oracle database from the Oracle official site. Set the password for the system/sys user you can set any password which you want to set. Now is the time to design our own user in the Oracle database but before designing the user we want to connect sys / system or any other user. Type command in SQL Command line: connect system/password SQl>show user To create our own user with Harshit name . - SQL> create user Harshit identified by abc; user id - Harshit Password- abc To connect with the Harshit user we need to assign the privileges. - SQL> grant connect, resource to Harshit; -SQL> grant dba to Harshit; - Now Harshit user can perform dba task also, all privilege affected on new session. -SQL> revoke dba from Harshit;...