create user rchintal identified by r06539  default tablespace users temporary tablespace temp;
grant connect, resource to rchintal with admin option;

create user agaddam identified by a06529  default tablespace users temporary tablespace temp;
grant connect, resource to agaddam with admin option;

create user skalapal identified by s40389  default tablespace users temporary tablespace temp;
grant connect, resource to skalapal with admin option;

create user rmangala identified by r06535  default tablespace users temporary tablespace temp;
grant connect, resource to rmangala with admin option;

create user vmekala identified by v06528  default tablespace users temporary tablespace temp;
grant connect, resource to vmekala with admin option;

create user zou identified by z86524  default tablespace users temporary tablespace temp;
grant connect, resource to zou with admin option;

create user jpagan identified by j03511  default tablespace users temporary tablespace temp;
grant connect, resource to jpagan with admin option;

create user bpathan identified by b06526  default tablespace users temporary tablespace temp;
grant connect, resource to bpathan with admin option;

create user arshah identified by a87596  default tablespace users temporary tablespace temp;
grant connect, resource to arshah with admin option;

% some queries 

select * from tson.courses, tson.transcripts where tson.courses.crscode = tson.transcripts.crscode;

% for System user with aministrator right 

