Explore BrainMass
Share

security and setup

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Describe steps necessary to setup SQL Server security.

Define what the database roles are and set them up for a database with import and export permissions.

Please provide atleast two screen shots of important steps.

© BrainMass Inc. brainmass.com October 24, 2018, 8:02 pm ad1c9bdddf
https://brainmass.com/computer-science/sql/database-security-setup-86446

Solution Preview

Please see the attached file.

SQL stands for the Structured Query language. It is the language, which is used to retrieve the data from the database on the given conditions. The main statement of the SQL is the create statement which is used to create the database in the SQL. The other most important SQL statement is the Select statement, which is used to retrieve the data from the specified database on the giving conditions. The most important advantage of the SQL is that, we don't have to write the big query as in the other non-procedural language, in SQL.

Steps to be kept in mind while setup of the SQL

Privacy
Privacy means that the sender and the receiver expect confidentiality. The transmitted message should make sense to only the intended user. To all others, the message should be unintelligible.

In this way when the SQL is setup Software utility is to use while sharing of database from user to another user the another user should not have the permission to use the database. In this way the Privacy can be maintained while installation of the SQL software.

Authentication
Authentication is the process that the receiver is sure of the sender's identity and that the imposter has send the message.

In this way that while setting of the SQL the administrator should maintain the file, which consists of the Username and Password of the Valid. When the User wants to work on the software firstly he should be ...

Solution Summary

This job discusses database roles.

$2.19
See Also This Related BrainMass Solution

Security Basics

Scenario:
You are an independent consultant who specializes in Information Technology security issues. You have been retained by the Designer Distributions Company, a mid-sized and growing consumer goods distribution company, for an assignment to assess the state of their computing environment security situation. The company's newly hired VP of IT is conducting this project because she does not have a security specialist on her staff and has learned that the company does not have a comprehensive security strategy. In fact, she suspects lack of even basic security knowledge in both the IT staff and the user community.

The company has a headquarters office building, which includes the principal data center, and a separate warehouse linked to the office by an private data network. The warehouse has a small computing facility of its own for order shipment data entry and tracking. This computer is linked to the headquarters order entry systems through the network. Additionally, there are Internet-based data links to several key suppliers used to share reorder, production and shipping schedules and status information. When potential new suppliers compete for contracts with Designer Distributions, their proposals are received and negotiated via Email.

You have been interviewing executives and staff at the company and at key suppliers and are beginning to evaluate what you have learned in preparation for preparing your report to the VP of IT.

The hot topic at your security networking group is an organization's overall approach to security standards and procedures and authorizations. Which is more in line with your thinking:

Security policies and procedures should be designed at a point in time and then enforced without modification to prevent arbitrary compromising of any element of the complete security architecture.
Security policies and procedures need constant review and revision to take into account changes in the systems, staff, and business partners.

View Full Posting Details