Creating User in Oracle with required Grants.

Creating User in Oracle  with required Grants.

Example:

create user lookup_fis
  identified by lookup_fis
  default tablespace users
  temporary tablespace TEMP
  profile DEFAULT;

-- Grant/Revoke role privileges
grant connect to lookup_fis;
grant dba to lookup_fis;
grant resource to lookup_fis;
-- Grant/Revoke system privileges
grant alter session to lookup_fis;
grant comment any table to lookup_fis;
grant create any table to lookup_fis;
grant create materialized view to lookup_fis;
grant create procedure to lookup_fis;
grant create sequence to lookup_fis;
grant create session to lookup_fis;
grant create synonym to lookup_fis;
grant create trigger to lookup_fis;
grant create type to lookup_fis;
grant create view to lookup_fis;
grant drop any table to lookup_fis;
grant unlimited tablespace to lookup_fis;
-- Set the user's default roles
alter user lookup_fis
  default role connect;