Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATABASE SECURITY - Coggle Diagram
DATABASE SECURITY
Authorization rules
Objects
Specific columns in a table
Specific rows in a table
Entire table
Actions
Read
Modify
Insert
Write
Delete
Grant
Subjects
Group of
users
Specific people
Constraint
Security Statements
CREATE ROLE
Named group of privileges
CREATE ROLE ISPManager;
CREATE ROLE ISAdministrator WITH ADMIN
CURRENT_ROLE;
CREATE ROLE ISEmployee;
GRANT
UPDATE
SELECT
INSERT
DELETE
TRIGGER
REFERENCES
EXECUTE
CREATE USER
Connect from any host
CREATE USER user_account
IDENTIFIED BY password;
REVOKE
Remove an access
privilege
REVOKE SELECT ON projects
FROM ISEmployee RESTRICT;
C.I.A. security model
Integrity
Availability
Confidentiality
Discretionary Access Control
Subject-Based Security
Subjects are individually defined in
the DBMS and each object and action is specified.
Object-Based Security
Objects are individually defined in
the DBMS and each subject and action is specified.
Mandatory Access Control
Object security class
Subject security clearance
.
Secret
Public
Top-Secret
Encryption
Plaintext - changed original data
Ciphertext - restoring of encrypted data
What is Security?
it`s protecting a database from unauthorized
access and malicious destruction