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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial