devxlogo

User Creation and Scenarios

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.

devx-admin

Share the Post: