How to use Login Information Parser Plugin?

brindas1 over 7 years ago

Hi all,
How to use "Login Information Parser" plugin? I have added this plug in so that now it can be used as a smart service. I have created "logins" table which now exists in the data source. How can I get the login details of the users using this smart service and table? Can someone please explain the steps?

Discussion posts and replies are publicly visible

Parents

0 brindas1 over 7 years ago

@mayureshs The script is as follows:

CREATE TABLE "SAMPLE.BUSINESS"."logins"
(          "id" NUMBER(10,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOT NULL ENABLE,
          "date" DATE,
          "time" TIMESTAMP (9),
          "lineNumber" NUMBER(10,0),
          "isValidLogin" NUMBER(1,0),
          "username" VARCHAR2(100 CHAR),
          "ipaddress" VARCHAR2(20 CHAR),
           CONSTRAINT "SUPPLIER_UNIQUE" UNIQUE ("id", "lineNumber")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 brindas1 over 7 years ago

@mayureshs The script is as follows:

CREATE TABLE "SAMPLE.BUSINESS"."logins"
(          "id" NUMBER(10,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOT NULL ENABLE,
          "date" DATE,
          "time" TIMESTAMP (9),
          "lineNumber" NUMBER(10,0),
          "isValidLogin" NUMBER(1,0),
          "username" VARCHAR2(100 CHAR),
          "ipaddress" VARCHAR2(20 CHAR),
           CONSTRAINT "SUPPLIER_UNIQUE" UNIQUE ("id", "lineNumber")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data