Blame | Last modification | View Log | Download | RSS feed
create table WS_UTENTI
(
USERNAME VARCHAR2(20) not null,
PASSWORD VARCHAR2(100) not null,
COGNOME VARCHAR2(100),
NOME VARCHAR2(100),
EMAIL VARCHAR2(100),
LOGIN VARCHAR2(20) not null,
USR_SYSTEM NUMBER(1),
USR_ENABLED NUMBER(1),
USR_LEVEL NUMBER(2),
USR_CREATE_DATE DATE,
USR_EXPIRATION NUMBER(1),
USR_EXPIRATION_DATE DATE,
USR_EXPIRED_ALOWED_LOGINS NUMBER(3),
USR_EXPIRED_REMAINING_LOGINS NUMBER(3),
USR_PWD_DURATION NUMBER(3),
USR_PWD_MODIFY NUMBER(1),
USR_PWD_FORCE_CHANGE NUMBER(1),
USR_FLAG_LOGON NUMBER(1),
USR_FLAG_MSG NUMBER(1),
USR_LAST_DOMAIN NUMBER(10),
USR_LAST_APPL NUMBER(10),
USR_LAST_PROFILE NUMBER(10),
USR_LAST_CONNECTION DATE,
USR_RAGGR_ENTI NUMBER(4),
USR_LOGO NUMBER(4),
USR_FLAG_PLAN NUMBER(1)
)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_UTENTI
add constraint PK_WS_UTENTI primary key (USERNAME)
using index
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_UTENTI
add constraint FK_WS_UTENTI_02 foreign key (USR_LEVEL)
references WS_TIPO_UTENTE (ID_TIPO_UTENTE);
create unique index PK_WS_UTENTI_LOGIN on WS_UTENTI (LOGIN)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
grant select on WS_UTENTI to &MONIT_USER_NAME;