Create Oracle users with correct permissions in wcs commerce



      Create Oracle users with correct permissions

·       Login to Oracle SQL developer as a master user

·       Run the following scripts to create a database user and DBA user. Make sure you change username according to the environment. If createInstance fails and you need to drop and recreate users, you don’t need to run the “create tablespace” command again.

 

# Install/Configure Oracle database

# Configure the oracle database

#Change the user and passwords according to the environment

create tablespace WCTBLSPC datafile size 100M autoextend on next 2M maxsize unlimited;

CREATE USER jbdev2user IDENTIFIED BY jbdev2user DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";

CREATE USER jbdev2dba IDENTIFIED BY jbdev2dba DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";

grant create procedure, create sequence, create session, create synonym, create table,create trigger, create view, create materialized view to jbdev2user;

ALTER USER jbdev2user QUOTA UNLIMITED ON WCTBLSPC;

-- QUOTAS

ALTER USER jbdev2user QUOTA UNLIMITED ON WCTBLSPC;

ALTER USER jbdev2user QUOTA UNLIMITED ON USERS;

 

-- ROLES

GRANT "CONNECT" TO jbdev2user;

 

-- SYSTEM PRIVILEGES

GRANT CREATE TRIGGER TO jbdev2user;

GRANT CREATE MATERIALIZED VIEW TO jbdev2user;

GRANT CREATE SESSION TO jbdev2user;

GRANT CREATE TABLE TO jbdev2user;

GRANT CREATE SYNONYM TO jbdev2user;

GRANT CREATE SEQUENCE TO jbdev2user;

GRANT CREATE PROCEDURE TO jbdev2user;

GRANT CREATE VIEW TO "JBDEV2USER";

-- QUOTAS

ALTER USER jbdev2dba QUOTA UNLIMITED ON WCTBLSPC;

ALTER USER jbdev2dba QUOTA UNLIMITED ON USERS;

 

-- ROLES

GRANT "DBA" TO jbdev2dba;

GRANT "CONNECT" TO jbdev2dba;

Comments

Post a Comment

Popular posts from this blog

Docker build

 The `docker build` command is used to build Docker images from a `Dockerfile`. This command automates the process of creating a Docker image by executing the instructions defined in the Dockerfile. Let’s break down the internal workings of `docker build` step by step: --- ### 1. **What is `docker build`?** The `docker build` command creates a Docker image from a **Dockerfile**, which is a text file that contains a series of instructions on how to assemble the image. The process takes the base image, applies modifications step-by-step (such as adding files, installing packages, or setting environment variables), and creates a final image that can be used to run containers. ### 2. **Command Syntax** ```bash docker build [OPTIONS] PATH | URL | - ``` - **PATH**: This is the path to the directory containing the `Dockerfile`. It can also be a URL or `-` (for reading from stdin). - **OPTIONS**: There are several options available, like `-t` for tagging, `--file` for specifying a differen...
Read more

Create wcs instance

      Create WCS instance ·        Log in to WCS server as wcsadmin. ·        Open the following file /opt/IBM/WebSphere/CommmerceServer80/schema/oracle/wcs.data.sql ·        Replace INSERT INTO dmelementnvp (dmelement_id, name, value) select i,n,v from (SELECT dmelement_id, 'socialActivityType', '*' FROM dmelement WHERE dmeletemplate_id IN (160, 215) UNION ALL SELECT dmelement_id, 'comparison', 'any' FROM dmelement WHERE dmeletemplate_id IN (160, 215)) s (i,n,v) where not exists (select 1 from dmelementnvp where dmelement_id = i and name = n and value = v);   With: INSERT INTO dmelementnvp (dmelement_id, name, value) select i,n,v from (SELECT dmelement_id i, 'socialActivityType' n, '*' v FROM dmelement WHERE dmeletemplate_id IN (160, 215)                    UNION...
Read more