Describe a general company security policy for database

Assignment Help Database Management System

Reference no: EM13765910

1. Describe a general company security policy for the database "layer" of security only (avoid getting into network security protocols or application level security for this exercise, and assume that there are security mechanisms in place that allow end-user connections to the database with the appropriate user credentials.)

2. Specify the SQL you will use to carry out your security policy for two of the business rules or areas of security concern. This may include creating a VIEW and/or ROLES and/or privilege GRANTs. Specify the rule, and BRIEFLY describe how your SQL carries this out. Please limit yourself to two areas of concern, but try to make sure you demonstrate you knowledge of how to efficiently and effectively organize your security controls.

3. Describe your general database backup plans for this system. More important than the plan itself is the rationale you provide for your decisions about the timing, backup types and backup media choices in your plan, which should be grounded in the facts provided in the business case.

Reference no: EM13765910

Questions Cloud

Different species of lizards : What would happen if a species of lizards were suddenly split into 2 groups by a hurricane,resulting in isolation of a small group of individuals on an island far from the mainland?

Process of routers and switches : Do you think that one day, routers and switches will not be needed? Why?

What did each of the individuals contribute to the world : What did each of the individuals contribute to the world? How was each of these contributions rooted in creative thinking; that is, how did each change existing paradigms of seeing or experiencing the world?

Provide network services : Your organization opened seven new branch offices in five states. Each branch office has five floors. All the branch offices use the same Internet domain name.

Describe a general company security policy for database : Describe a general company security policy for the database "layer" of security only (avoid getting into network security protocols or application level security for this exercise, and assume that there are security mechanisms in place that allow ..

Write an essay on gender stereotyping in media : Write an essay on gender stereotyping in Media in general but this specific topic is focused on gender stereotyping in magazines and I have the article I would like you to research.

Knowledgable in nursing field issues : Evaluates Personal Engagement With Natural Rhythms and Other Basic Determinants of Holistic Health.

Evaluate each hazard for severity and frequency : Evaluate each hazard for severity and frequency, Estimate the risk, Determine the societal and economic (direct) effects and the indirect effects or costs

Establishing the predetermined overhead rates : Autovalet Manufacturing uses a job order cost system in each of its three manufacturing departments. Manufacturing overhead is applied to jobs on the basis of direct labour cost in Department A, direct labour hours in Department B and machine h..

User Account

All Pages