Thursday, September 8, 2016

Create ora1 user

DROP USER ora1 CASCADE;

CREATE USER ora1
  IDENTIFIED BY ora1
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  -- 2 Roles for ora1
  GRANT RESOURCE TO ora1;
  GRANT SELECT_CATALOG_ROLE TO ora1;
  ALTER USER ora1 DEFAULT ROLE ALL;
  -- 7 System Privileges for ora1
  GRANT ALTER SESSION TO ora1;
  GRANT CREATE DATABASE LINK TO ora1;
  GRANT CREATE SEQUENCE TO ora1;
  GRANT CREATE SESSION TO ora1;
  GRANT CREATE SYNONYM TO ora1;
  GRANT CREATE VIEW TO ora1;
  GRANT UNLIMITED TABLESPACE TO ora1;
  -- 1 Object Privilege for ora1
    GRANT EXECUTE ON SYS.DBMS_STATS TO ora1;
------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment