Create Login Form with Advance Security Level Part 1 of 3

Login with Different Security Level

---

Closed Caption:

LOL come back to my video of my name is
21 in this video I will show you how to
create a login or implement login form
with the different security level i got
an email from our friend broken express
from hotmail are here I to see that with
you all you need help with the lock-in
witness different security level asking
request intercourse like a sick
different security level of permission
the first login with admin we have a
full access we'll modify or the
employer-employee rekha second long as a
guest to have exit or evil only got no
modification at the third time I is a
long in that as Corky control here we
have the exit to Real and modify area on
our his department quality control
department cannot see another Department
employee for login as a technical same
thing to wheel and edit re technical
department trip log in the middle sharp
Department you and or modify sorry for
me to shop department and the sixth
login as regular user we have a say to
you are his all record Holly cannot see
another employee department or another
employee record and i will show you how
to do this first we have to create some
kind of like um or modified security
table they put different time in there
for me on that I we implement on the
create login form a program that i
always show you in another video if you
have one was it and you
and go back and watch the to create
login form in this one we just want to
implement on at a program now we have to
create table department because in his
request to have a three different
Department quality control technical and
photoshop they create that and hopefully
you know how to create the table which
are like this go to the side view
department ID at auto number call you
can put number inside yourself and
department name tag
that's it the next step we have to edit
some secret security level before that
they have already admin user now we need
to realize that p.m. admin you can add
another how I feel in here excess label
for access the description in here we
have guests always control technical
meto and user and we added our guests
you only and quality control you and
added on courage controlled apartment
Holly and technical middle we donated
already on the comment and the six level
for the user will his own record only we
had this one seek permission to seek
level one security little table
ok say that now on do i have to work a
cable we have username login use of time
and you sir password now we need to add
department name in here because we add a
department table department table and
now on the b-side you up working table
after password
is a tank and department name use like a
blow-up it's already done
you can see the lookout form a role
sauce here prob cable and query chicken
here select department ID and the main
and now it's linked to department table
by the ID Department idea we show that
is a number or you can check on the
relationship here and this one we can be
laid all this we can add a table and
show the live ship we have the table
security level already a table and the
same here department ID link to
department name and security ID to use a
time or hear that how the database going
to shower now we need to add some deep
silicon here department down the case we
don't put any Department year and now
I'm to add mean we just leave it bang
because you want to see all the
department and use a a weighing on you
see here aside too dependent noodle shop
and just made John Smith for me to shop
and then decide to use of time in from
use of security to me to shop to and
from neither shall be partner in all you
don't want you don't have to put
department name in here because we
select from reducing high security tie
already but some case we just want to
show the apartment for this worker
ok now after we complete the department
table update the security level and
update the table worker what he
requested school to admin we have me to
have full control guess you only we need
to update some cold on the login form
first for this because we're gonna set
some security level of permission when
the user login are longing from the end
go to create human position people kid
that this one
re you know you on the previous video
how to create a login form which is all
this Court talking about and it go to
this tip give the user level equal one
is mad mean else and then send out all
this information along in ID working
name and open the navigation form
ok we want to go back to the dedication
from in go to the side view we have been
here we send the information you see the
name in a username
when we clock-in and then login
information form you see the tape user
and then take login will be said RSI
with do take user will be equal to full
name
a worker working name equal to yeah the
worker named matching with the take
login user and ID ID may be sure it over
here is it take ID and now we also need
to security number two because we want
to pass the over here
security time this one issue as a number
because this link to security level
table can see the resided here you see
the tight secure satellite is a number
we do what I just want to add another
take back their security time and this
one maybe at like a pic security
ok but this part we make it show first
and later on we can make it invisible
now we got to take security on this one
save it and on the court now we need to
add some yeah what we have is just copy
it lie here
and change it to you pretty and now we
need to create some kind of look up here
we have enough of name full name and
password and we need one more here we
can use like any excess label here and
just copy one life from here and change
it to access level and then look out
form you can go back and see what's the
name when here is a no use of time
lookup use of time
okay in the cable worker and then we put
up now there's take security equal to
access level
ok say when now we want to combine this
one because we have more than now one or
two later we need to specify our every
single level at different now
excess now we need to provide the court
under the login form in here in this
part on we need to realize that before
we go to the security level or worldwide
security we need to open it up to after
else we need to open the navigation form
and aside along an ID to take long in
inside the full name or a worker to take
user aside
security level access level to take
security and then bounces to the first
page and we can delete this part out now
and we call the function i have created
the function is that secrete down here
it security
ok we're apart the security level which
is can access level access level is an
integer you can see from here is integer
and hard to hear and we call after we
open that and then we call our security
level and we need to create a sub
function insecurity user-level from here
we have the six different user as we
specify under the security level table
here at mean equal 12 is get 325
department and cities user now we have
to put anyone is fast food control how
we use the silicates statement here
case 2 equal to guess and you only s34 y
equal to the courage to control nature
shop and technical department and we
will edit on daddy comment re seekers
user will we are on their own liquor
only now we need to add some more hot in
here after we opened the navigation for
me si everything and
are we to open all make the form
depending on the security level day
logging we can test with his use of you
know the message back here and you log
in as a user for number six and with
Department equal to $OPERAND department
ID and we put in here Department part ID
as integer and now we need to add some
here to there by D welcome from them I
day we need to ask more another live
code here in here I reset the department
department ID is as in the German
forename depart ID Department idea eco
2d look up on the department and pay
load up on this one department name
department name
ok and we passed that 12 Department idea
and then pass it to the function
security equal to $OPERAND department
idea
Oh for now when we long on to answer you
sir we need to disable the admin
function which is over here
admin page the name of this is
navigation but to no routine and we we
can we make it visible for now it can
you want to see the login ID save close
now it tastes long in the form itwould
g-going 1234
ok and department we have 2t here which
is great now we're long as the user we
caught the security ties sick and G wing
is long in ID pass from the login form
to the navigation format full name is
John way and if I many equal to 3 which
is equal to three well here is made shop
and before the show energy when you so
that made a shop here see and which is
good on and under admin . is disabled in
winning login has a user with the
security level is 66 million uses an
audience j-john wang and my info is
supposed to be sure John way here we
need to go to this five you under my
influence creek on the form the clicking
and UVC on the plane we need to update
some court on the glory win when we
opened ass user info tab it be always
show under
you name all the user login name we go
by aside in user and bring me mine
login in tissue game pass and strain and
as I use equal to two work to form
navigation home near occasion from and
when come from that one it come from
here you see the order is take long in
the take long in the login user from
there and then now assign my long in ID
ID from table worker and criterias long
in
i equal to $OPERAND single a trace on
you soon number crossing called and
double quotes and as I tasks equal to
the extent that all form table where
workers ide go to this teacher we need
always double court my lock and then SI
me . because source equal to $PERCENT
chance and that's it
same clothes and we run it is going here
and allowing G wing can be creative mind
to support to be saving our we can
disable this one because we don't want
to use the chain them on the side view
and click on here we can put down kick
on data and number would know below
yes we're now we cannot create on issues
because we lock you anything useful to
chain security tile security level they
can change their password on changing
name
okay we're done with the sio readers the
user record tutor user login