Friday, February 24, 2017

Creating a User


  1. CREATE USER LIMA IDENTIFIED BY LIMA;
  2. GRANT CONNECT TO LIMA;
  3. GRANT CONNECT, RESOURCE, DBA TO LIMA;
  4. GRANT CREATE SESSION GRANT ANY PRIVILEGE TO LIMA;
  5. GRANT UNLIMITED TABLESPACE TO LIMA;
  6. GRANT SELECT, INSERT, UPDATE, DELETE ON schema.emp_mast TO LIMA;

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/