Security - Oracle WebLogic Server 12c Advanced Administration - page 244

ADD CONSTRAINT PK_GROUPMEMS PRIMARY KEY ( G_NAME, G_MEMBER );
ALTER TABLE GROUPMEMBERS
ADD CONSTRAINT FK1_GROUPMEMBERS FOREIGN KEY ( G_NAME )
REFERENCES GROUPS (
G_NAME) ON DELETE CASCADE;
2. Populate the tables with the default WebLogic groups:
INSERT INTO GROUPS (G_NAME,G_DESCRIPTION) VALUES ('AdminChannelUse
rs','AdminChannelUsers can access the admin channel.');
INSERT INTO GROUPS (G_NAME,G_DESCRIPTION) VALUES ('Administrators
','Administrators can view and modify all resource attributes and
start and stop servers.');
INSERT INTO GROUPS (G_NAME,G_DESCRIPTION) VALUES
('AppTesters','AppTesters group.');
INSERT INTO GROUPS (G_NAME,G_DESCRIPTION) VALUES ('CrossDomainCon
nectors','CrossDomainConnectors can make inter-domain calls from
foreign domains.');
INSERT INTO GROUPS (G_NAME,G_DESCRIPTION) VALUES
('Deployers','Deployers can view all resource attributes and
deploy applications.');
INSERT INTO GROUPS (G_NAME,G_DESCRIPTION) VALUES
('Monitors','Monitors can view and modify all resource attributes
and perform operations not restricted by roles.');
INSERT INTO GROUPS (G_NAME,G_DESCRIPTION) VALUES
('Operators','Operators can view and modify all resource
attributes and perform server lifecycle operations.');
INSERT INTO GROUPS (G_NAME,G_DESCRIPTION) VALUES
('OracleSystemGroup','Oracle application software system group.');
COMMIT;
Access the Administration Console to create the new data source ds-Provider :
1. Access the Administration Console by pointing your web browser to
http://adminhost.domain.local:7001/console .
2. Click on the Lock & Edit button to start a new edit session.
3. Expand the Services tree to the left, and then click on Data Sources.
4. Click on the New button and then click on Generic Data Source.
5. Enter ds-Provider in the Name field and jdbc/ds-Provider in the JNDI Name
field. Leave the Database Type drop-down menu with the Oracle option selected.
Click on the Next button.
6. Choose *Oracle's Driver (Thin) for Service connections;
Versions:9.0.1 and later from the Database Driver drop-down menu.
Click on the Next button.