Scribd
Upload
4 views2 pages

User Type Data

The document outlines the creation of a database table named 'user_type' which includes fields for user type ID, name, description, action user, and action date/time. It establishes a primary key constraint on the user type ID and inserts 15 different user types with corresponding descriptions. The user types range from 'Normal User' to 'Project Admin' and include various roles such as 'Administrator' and 'Developer'.

Uploaded by

Shahinur Rahman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views2 pages

User Type Data

The document outlines the creation of a database table named 'user_type' which includes fields for user type ID, name, description, action user, and action date/time. It establishes a primary key constraint on the user type ID and inserts 15 different user types with corresponding descriptions. The user types range from 'Normal User' to 'Project Admin' and include various roles such as 'Administrator' and 'Developer'.

Uploaded by

Shahinur Rahman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

--1.

user type---
----------------

create table user_type


(
user_type_id number,
user_type_name varchar2(100) constraint user_type_user_type_name_nn not
null
constraint user_type_user_type_name_uk
unique,
user_type_description varchar2(300),
action_user varchar2(100) default user,
action_date_time timestamp default sysdate
) ;

desc user_type

alter table user_type


add constraint user_type_user_type_id_pk primary key(user_type_id) ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (1, 'Normal User', 'This is Normal User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (2, 'System', 'This is System User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (3, 'Administrator', 'This is Administrator User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (4, 'Standard', 'This is Standard User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (5, 'Guest', 'This is Guest User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (6, 'Read_only', 'This is Read_only User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (7, 'Casual', 'This is Casual User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (8, 'Naive', 'This is Naive User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (9, 'Sophisticated', 'This is Sophisticated User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (10, 'Developer', 'This is Developer User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (11, 'Internal', 'This is Internal User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (12, 'External', 'This is External User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (13, 'Regular', 'This is Regular User') ;
insert into user_type(user_type_id, user_type_name, user_type_description)
Values (14, 'Higher Authority', 'This is Higher Authority User') ;

insert into user_type(user_type_id, user_type_name, user_type_description)


Values (15, 'Project Admin', 'This is Project Admin User') ;

You might also like