create table user$ /* user table */ ( user# number not null, /* user identifier number */ name varchar2("M_IDEN") not null, /* name of user */ /* 0 = role, 1 = user, 2 = adjunct schema, 3 = schema synonym */ type# number not null, password varchar2("M_IDEN"), /* encrypted password */ datats# number not null, /* default tablespace for permanent objects */ tempts# number not null, /* default tablespace for temporary tables */ ctime date not null, /* user account creation time */ ptime date, /* password change time */ exptime date, /* actual password expiration time */ ltime date, /* time when account is locked */ resource$ number not null, /* resource profile# */ audit$ varchar2("S_OPFL"), /* user audit options */ defrole number not null, /* default role indicator: */ /* 0 = no roles, 1 = all roles granted, 2 = roles in defrole$ */ defgrp# number, /* default undo group */ defgrp_seq# number, /* global sequence number for the grp * spare varchar2("M_IDEN"), /* reserved for future */ astatus number default 0 not null, /* status of the account */ /* 0x00 = 0 = Open */ /* 0x01 = 1 = Locked */ /* 0x02 = 2 = Expired */ /* 0x03 = 3 = Locked and Expired */ /* 0x10 = 16 = Password matches a default value */ lcount number default 0 not null, /* count of failed login attempts */ defschclass varchar2("M_IDEN"), /* initial consumer group */ ext_username varchar2("M_VCSZ"), /* external username */ /* also as base schema name for adjunct schemas */ spare1 number, /* used for schema level supp. logging: see ktscts.h */ /* spare2 is used to store */ /* - edition id for adjunct schemas (type# = 2) */ /* - base schema id for schema synonyms (type# = 3) */ spare2 number, spare3 number, spare4 varchar2(1000), spare5 varchar2(1000), spare6 date ) cluster c_user#(user#) |