Instruction for users, roles and privileges Project must be done in Microsoft Imagine and Microsoft Visio software, oracle 11g, read all instructions very carefully. Make sure you follow the scoring guide very carefully. Make sure the writer follow instructions very carefully.
Users, Roles, and Privileges
Create a strategy to create users, roles, and privileges based on organizational needs. Separating users, roles, and privileges is a must for any organization to establish security. Planning a strategy so that users are not hindered by too much security while ensuring that database objects are properly secured is an important balance.
Assessment Instructions
Your organization’s environment requires you to setup various user accounts to support the new application being built. Some of the systems will require some new user accounts to help support the development, support, and productions teams over the development, QA, and production databases.
Preparation
Research the following in preparation for this assessment:
• Creating an externally authenticated account.
You may use the suggested resources or other scholarly and professional resources from your independent research to learn more about these topics.
Directions
For this assessment, complete the following:
• Create a script to permit externally authenticated user accounts to login and provide the account with correct privileges.
• Create a simple database, or use an existing one, to plan and design various roles and views on the data.
• Devise a strategy for creating at least three different roles, based on the needs of the organization.
• Create a script to create the accounts, roles, and permissions over each database.
• Devise a strategy to evaluate business requirements to define an organization’s users and roles.
Once you have completed your roles and views for your database, write a walkthrough tutorial for the administrators in which you address the following:
• Create a script to permit externally authenticated user accounts to login and providing the account with correct privileges.
• Design a strategy for creating three different roles, based on the needs of your organization.
• Explain the strategy to evaluate business requirements to define an organization’s users and roles with their appropriate privileges.
• Create the SQL code to create three different roles.
• Communicate in writing that is clear and free from errors that detract from the overall message.
Users, Roles, and Privileges Scoring Guide
Users, Roles, and Privileges Scoring Guide
CRITERIA NON-PERFORMANCE BASIC PROFICIENT DISTINGUISHED
Explain the strategy to evaluate business requirements to define an organization’s users and roles with their appropriate privileges. Does not explain the strategy to evaluate business requirements to define an organization’s users and roles with their appropriate privileges. Describes strategy for some of the business requirements to define the organization’s user and roles but the strategy is missing some key choices. Explains the strategy to evaluate business requirements to define an organization’s users and roles with their appropriate privileges. Explains the strategy to evaluate business requirements to define an organization’s users and roles with their appropriate privileges following industry best practices.
Create a script to permit externally authenticated user accounts to login and provide the account with correct privileges. Does not create a script to permit externally authenticated user accounts to login and provide the account with correct privileges. Creates a script to permit externally authenticated user accounts to login, but the script has errors. Creates a script to permit externally authenticated user accounts to login and provides the account with correct privileges. Creates a script to permit externally authenticated user accounts to login and provides the account with correct privileges and proper verification documentation and examples.
Design a strategy for creating three different roles based on the needs of your organization. Does not design a strategy for creating at least three different roles based on the needs of an organization. Designs a strategy for creating at least three different roles based on the needs of an organization, but the design is incomplete or inaccurate. Designs a strategy for creating at least three different roles, based on the needs of an organization. Designs a strategy for creating all possible roles based on the needs of an organization that would interact with the database.
Create the SQL code to create three different roles. Does not create the SQL code to create three different roles. Creates the SQL code to create three different roles, but the code is incomplete or inaccurate. Creates the SQL code to create three different roles. Creates the SQL code to create all of the different roles based on the needs of an organization.
Communicate in writing that is clear and free from errors that detract from the overall message. Communicates in writing that is neither clear nor free from errors that detract from the overall message. Communicates in writing that is vague or includes errors that detract from the overall message. Communicates in writing that is clear and free from errors that detract from the overall message. Communicates in writing that is clear, well-organized, and free of grammatical errors.

Leave a Reply

Your email address will not be published. Required fields are marked *

11 + nineteen =

This site uses Akismet to reduce spam. Learn how your comment data is processed.