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:

  1. Install the Oracle database from the Oracle official site.
  2. Set the password for the system/sys user you can set any password which you want to set.
  3. 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.
  4. 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; - until re-login Harshit user work as dba, but after re-login Harshit user will work as the normal user.

Change the user password

If we want to change the user password then we can change our own password but the dba user can change any user password.
 SQL> alter user Harshit identified by rewq;

Lock and Unlock the user

If we want to lock and unlock the existing user the the following command:
SQL> alter user Harshit account lock;   -To lock the account
SQL> alter user Harshit account unlock;   -To unlock the account

For expire the user password type:
SQL>alter user Harshit password expire;

Display the list of all existing user;

To display the list of all the existing use in the database type :
SQL> select* from all_user;

To display the current working user type :
SQL>show user;

To drop the existing user type:
SQL>drop user Harshit; -If the user table is linked with another user table then an error will generate.
SQL>drop sure Harshit cascade; - Drop the user forcefully. 



Comments

Post a Comment

DON'T COMMENT LINK.

Popular posts from this blog

Remove Tools From Termux | How can I reopen the installed tool in termux? | TECH WORTHY MIND

-
Image
In this Termux tutorial we will learn how to remove tool in termux, how to uninstall any tool in termux and how can i reopen the install tool in termux. By follow some simple steps you can easily uninstall any tool in termux. Termux is a application in which you can easily install the different commands which perform hacking like Zispher command etc. How to delete tool from termux some useful steps which mention below follow all steps to uninstall tool in termux Open your android terminal emulator (Termux) Type command $ cd and press enter. Type $ ls command, after that all the tools which previously installed in you termux will display. Type command $ rm -rf toolName and press enter then successful your tool delete from termux. How can I reopen the installed tool in termux  Simply open your termux and type $ cd and press enter. In second step type command $ ls After that write $ cd toolname and enter. In the last step enter $ bash toolname.sh In this way you can successfully switch yo
Read more

How To Hack Wifi | Hack Wifi Password | TECH WORTH MIND

-
Image
  How to hack wifi password and how to hack wifi using termux. By follow some simple steps you can easily hack wifi. Open your termux app and paste all command one by one. Hacking How to hack wifi password using Termux 100% working ,how to hack wifi password on android phone without app. useful steps-: 1- pkg update 2- pkg upgrade 3- pkg install python 4- pkg install python2 5- pkg install git 6- pkg install requests 7- pkg install mechanize 8- git clone https://github.com/king-hacking/ King-Hacking 9- cd King-Hacking 10- bash King-Tools.sh         ffffff
Read more