Granting System Privileges

• CREATE SESSION : Connect to the database
• CREATE TABLE : Create tables in the user's schema
• CREATE SEQUENCE : Create a sequence in the user's schema
• CREATE VIEW : Create a view in the user's schema
• CREATE PROCEDURE : Create a stored procedure, function, or package in the user's schema
  

Syntax )

GRANT privilege [, privilege...]
TO user [, user | role, PUBLIC...];

Current system privileges can be found in the SESSION_PRIVS dictionary view.

ex)

GRANT create session, create table, create sequence, create view
TO scott;