The Grant statement

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. 

Get Learning Linux Shell Scripting - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.