This discussion is archived
1 Reply Latest reply: Dec 3, 2012 8:49 PM by Faisal Khan RSS

SQLAuthenticator :- User Not Listing

Gijith Newbie
Currently Being Moderated
Hi experts,
My WebLogic Server Version: 10.3.5.0.

I created a SQLAuthenticator Provider in my Security Realms
I set its control flag as Sufficient. Provided the data source name and all other settings. I modified the queries according to my table structure as below

CREATE TABLE USERS
(
U_ID VARCHAR (12) NOT NULL,
U_PASSWORD VARCHAR (50) NOT NULL,
U_NAME VARCHAR (1000)
);

CREATE TABLE GROUPS
(
G_NAME VARCHAR (200) NOT NULL,
G_DESCRIPTION VARCHAR (1000) NULL
);

CREATE TABLE USER_GROUPS
(
G_NAME VARCHAR (200) NOT NULL,
G_MEMBER VARCHAR (200) NOT NULL
);

By using weblogic console i can able to create user and the user is successfully created in database table. But my issue is the created user is not listing in weblogic user list.
Help me to solve this issue.
Thanks in advance.
gtg

Edited by: gtg on Nov 27, 2012 12:52 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points