security - CSE 412/598 DATABASE MANAGEMENT COURSE NOTES 12....

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
CSE 412/598 DATABASE MANAGEMENT COURSE NOTES Arizona State University
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CSE 412/598 2 SECURITY & AUTHORIZATION SUBSYSTEM protects the database from malicious access Security mechanisms: discretionary - privileges mandatory - multilevel security by classification of data and users Responsibility of DBA account creation to restrict access to the DB privilege granting/revocation security level assignment Statistical database security is also a concern. ..
Background image of page 2
CSE 412/598 3 DISCRETIONARY PRIVILEGES Account Level CREATE SCHEMA - create a database schema CREATE TABLE - create a base table CREATE VIEW - create a virtual table ALTER - to add or remove attributes from relations DROP - to delete relations or views MODIFY - to insert, delete, or update tuples SELECT - retrieve tuples by select Account level discretionary privileges are not defined as part of SQL2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/12/2010 for the course CSE 41412 taught by Professor Hassan during the Fall '10 term at University of Arizona- Tucson.

Page1 / 6

security - CSE 412/598 DATABASE MANAGEMENT COURSE NOTES 12....

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online