Wednesday, March 18, 2009

Oracle user script

create user a identified by a;
create user b identified by b;
create user c identified by c;
create user d identified by d;
create user e identified by e;
create user f identified by f;
create user g identified by g;
create user h identified by h;
create user i identified by i;
create user j identified by j;
create user k identified by k;
create user l identified by l;
create user m identified by m;
create user n identified by n;
create user o identified by o;
create user p identified by p;
create user q identified by q;
create user r identified by r;
create user s identified by s;
create user t identified by t;
create user u identified by u;
create user v identified by v;
create user w identified by w;
create user x identified by x;
create user y identified by y;
create user z identified by z;
create user aa identified by aa;
create user ab identified by ab;
create user ac identified by ac;
create user ad identified by ad;
create user ae identified by ae;
create user af identified by af;
create user ag identified by ag;
create user ah identified by ah;
create user ai identified by ai;
create user aj identified by aj;
create user ak identified by ak;
create user al identified by al;
create user am identified by am;
create user an identified by an;
create user ao identified by ao;
create user ap identified by ap;
create user aq identified by aq;
create user ar identified by ar;
create user at identified by at;
create user au identified by au;
create user av identified by av;
create user aw identified by aw;
create user ax identified by ax;
create user ay identified by ay;
create user az identified by az;
create user ba identified by ba;
create user bb identified by bb;
create user bc identified by bc;
create user bd identified by bd;
create user be identified by be;
create user bf identified by bf;
create user bg identified by bg;
create user bh identified by bh;
create user bi identified by bi;
create user bj identified by bj;
create user bk identified by bk;
create user bl identified by bl;
create user bm identified by bm;
create user bn identified by bn;
create user bo identified by bo;
create user bp identified by bp;
create user bq identified by bq;
create user br identified by br;
create user bs identified by bs;
create user bt identified by bt;
create user bu identified by bu;
create user bv identified by bv;
create user bw identified by bw;
create user bx identified by bx;
create user bz identified by bz;
create user ca identified by ca;
create user cb identified by cb;
create user cc identified by cc;
create user cd identified by cd;
create user ce identified by ce;
create user cf identified by cf;
create user cg identified by cg;
create user ch identified by ch;
create user ci identified by ci;
create user cj identified by cj;
create user ck identified by ck;
create user cl identified by cl;
create user cm identified by cm;
create user cn identified by cn;
create user co identified by co;
create user cp identified by cp;
create user cq identified by cq;
create user cr identified by cr;
create user cs identified by cs;
create user ct identified by ct;
create user cu identified by cu;
create user cv identified by cv;
create user cw identified by cw;
create user cx identified by cx;
create user cy identified by cy;
create user cz identified by cz;
create user da identified by da;
create user db identified by db;
create user dc identified by dc;
create user dd identified by dd;
create user de identified by de;
create user df identified by df;
create user dg identified by dg;
create user dh identified by dh;
grant connect,resource to a;
grant connect,resource to b;
grant connect,resource to c;
grant connect,resource to d;
grant connect,resource to e;
grant connect,resource to f;
grant connect,resource to g;
grant connect,resource to h;
grant connect,resource to i;
grant connect,resource to j;
grant connect,resource to k;
grant connect,resource to l;
grant connect,resource to m;
grant connect,resource to n;
grant connect,resource to o;
grant connect,resource to p;
grant connect,resource to q;
grant connect,resource to r;
grant connect,resource to s;
grant connect,resource to t;
grant connect,resource to u;
grant connect,resource to v;
grant connect,resource to w;
grant connect,resource to x;
grant connect,resource to y;
grant connect,resource to z;
grant connect,resource to aa;
grant connect,resource to ab;
grant connect,resource to ac;
grant connect,resource to ad;
grant connect,resource to ae;
grant connect,resource to af;
grant connect,resource to ag;
grant connect,resource to ah;
grant connect,resource to ai;
grant connect,resource to aj;
grant connect,resource to ak;
grant connect,resource to al;
grant connect,resource to am;
grant connect,resource to an;
grant connect,resource to ao;
grant connect,resource to ap;
grant connect,resource to aq;
grant connect,resource to ar;
grant connect,resource to at;
grant connect,resource to au;
grant connect,resource to av;
grant connect,resource to aw;
grant connect,resource to ax;
grant connect,resource to ay;
grant connect,resource to az;
grant connect,resource to ba;
grant connect,resource to bb;
grant connect,resource to bc;
grant connect,resource to bd;
grant connect,resource to be;
grant connect,resource to bf;
grant connect,resource to bg;
grant connect,resource to bh;
grant connect,resource to bi;
grant connect,resource to bj;
grant connect,resource to bk;
grant connect,resource to bl;
grant connect,resource to bm;
grant connect,resource to bn;
grant connect,resource to bo;
grant connect,resource to bp;
grant connect,resource to bq;
grant connect,resource to br;
grant connect,resource to bs;
grant connect,resource to bt;
grant connect,resource to bu;
grant connect,resource to bv;
grant connect,resource to bw;
grant connect,resource to bx;
grant connect,resource to bz;
grant connect,resource to ca;
grant connect,resource to cb;
grant connect,resource to cc;
grant connect,resource to cd;
grant connect,resource to ce;
grant connect,resource to cf;
grant connect,resource to cg;
grant connect,resource to ch;
grant connect,resource to ci;
grant connect,resource to cj;
grant connect,resource to ck;
grant connect,resource to cl;
grant connect,resource to cm;
grant connect,resource to cn;
grant connect,resource to co;
grant connect,resource to cp;
grant connect,resource to cq;
grant connect,resource to cr;
grant connect,resource to cs;
grant connect,resource to ct;
grant connect,resource to cu;
grant connect,resource to cv;
grant connect,resource to cw;
grant connect,resource to cx;
grant connect,resource to cy;
grant connect,resource to cz;
grant connect,resource to da;
grant connect,resource to db;
grant connect,resource to dc;
grant connect,resource to dd;
grant connect,resource to de;
grant connect,resource to df;
grant connect,resource to dg;
grant connect,resource to dh;