How to Create a User and Grant Permissions in Oracle

In this post, Learn how to create a user in oracle and How to provide grant permissions to the user in oracle.

How to Create a User in Oracle

Before creating a user in oracle, you must have admin access or system privilege to create new user and to create session.

Connect to Oracle as sysdba using following command. We are running this tutorial in Oracle 18C version.

H:\>sqlplus / as sysdba

Output:

H:\>sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Apr 16 12:47:26 2019
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL>

Only a user authenticated AS SYSASM/SYSDBA to create the user.