Post date: Dec 01, 2018 5:46:17 PM
Chapter 25: Introduction to Database Security
Introduction to Database Security Issues; Discretionary Access Control & Mandatory Access
Control; Intro to Statistical Database Security; Intro to Flow Control; Encryption; Privacy Issues
To see privileges of a user:
SHOW GRANTS [FOR username];
Creating a users:
CREATE USER username IDENTIFIED BY password;
Changing a user's password:
ALTER USER username IDENTIFIED BY new_password;
Granting a privilege:
GRANT privilege [, privilege, ...] ON schema.table TO username [, username, ...] [WITH GRANT OPTION] ;
Revoking a privilege:
REVOKE privilege [, privilege, ...] [, GRANT OPTION] ON schema.table FROM username [, username, ...] ;
Main privileges for tables:
SELECT
INSERT
UPDATE
DELETE
CREATE
ALTER
DROP
Interesting resource: