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

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...