Please enable JavaScript.
Coggle requires JavaScript to display documents.
CHAPTER 2: SOFTWARE SECURITY - Coggle Diagram
CHAPTER 2: SOFTWARE SECURITY
THREE TIER CLIENT/SERVER ARCHITECTURE input output sent to a layer to another
CLIENT
interect with GUI/ web interface
DATABASE
input will be sent here
APPLICATION SERVER
enter pw and username
DATABASE
stuctured collection of data stored for use by one or more application
DBMS
suite of program of constructing and maintaining the database
offer
RELATIONAL DATABASE ELEMENTS
COMPONENT
definition language
manipulation language
data dictionary
STRUCTURED QUERY LANGUAGE
standardize language to define, manipulate and query data in rtional database
element
select
from
where
threats to computer systems
THREE BASIC CONCEPT IN DS
AUTHENTICATION
mechanism determine whether user is who he she claims to be
AUTHORIZATION
granting right to subject to have access to a system or its object
ACCESS CONTROL
security mechanism for restricting access to system objects as whole
DATABASE ACCESS CONTROL
provide access control for dtbs
provide specific access rights to portions of database
support range policies
SQL ACCESS CONTROL
GRANT
REVOKE
CASADING AUTHORIZATIONS: I DIDN'T PAY ATTENTION WATCH UTUBE
ROLE BASED ACCESS CONTROL