We can provide the newly created user with privileges by using the GRANT command. GRANT is a very powerful command with many options. It will provide privileges to user while accessing database:
SQL> grant connect, resource to user1; You will get the following output: Grant succeeded.