An Oracle user configured in the DAS connection string requires certain permissions. As a database administrator, you must create two or more types of owners, such as Schema owner and Application owner, and assign the required permissions to them.

The following are the examples of permissions assigned to owners:

• Schema owner:

  CREATE USER schema_owner IDENTIFIED BY password
  DEFAULT TABLESPACE users
  TEMPORARY TABLESPACE temp
  QUOTA UNLIMITED ON users;
  GRANT CONNECT, CREATE TABLE TO schema_owner;

• Application owner:

  CREATE USER app_user IDENTIFIED BY password 
    DEFAULT TABLESPACE users 
    TEMPORARY TABLESPACE temp; 
  GRANT CONNECT TO app_user;