Please enable JavaScript.
Coggle requires JavaScript to display documents.
Security - Coggle Diagram
Security
Security Statements
create user
allows you to create a new user account
password
is specified in the identified by clause
must be in clear text
MySQL will encrypt it
create role
is a named group of privileges
all the role will be transferred to the user
one user can have one or more roles
grant
Privilege
trigger
references
delete
execute
insert
update
select
with grant option
revoke
to remove an access privilege
security triangle
Availability
Confidentiality
Integrity
database
database-level access
database-level authentification
data storage encryption