User Creation and Scenarios

Please understand that this USER named SRIDHAR is created without a password and is also dangerous.

CREATE USER SRIDHAR

Alternatively, you can use the code below to create with a password.

CREATE USER SRIDHAR IDENTIFIED BY ‘sridhar’ where the lowercase word is the password. This is secure to some extent.

This is not a complete syntax for user creation. The essence of this is to highlight the importance of providing a password during the user creation process itself.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: