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

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...