Explain how views and stored procedures could be used to help ensure the security of a database
What will be an ideal response?
Views present the user with a view of the data that is appropriate to their use of the database. Views can be used to hide the underlying structure of the tables and columns. This can help prevent a disgruntled user from attacking the underlying structure. Stored procedures can be used to capture INSERTS, UPDATES, and DELETES and make sure they occur safely.
You might also like to view...
As the newest member of the marketing department, your immediate boss asks you to comment on the company's proposal to add two new shoes to the company's middle-of-the-road pricing and product-line strategies
The first pair will retail for $ 40 and has as its target market the "bargain" shopper. The second pair will retail for $200 and is targeted at the "sophisticated shopper." In relation to product-line strategy, what is the company trying to accomplish with these two new items?
Which of the following is a main trait needed to be an effective public relations writer?
A) knowledge of basic writing principles B) good eye-hand coordination for keyboarding C) skill at surfing the Internet D) ability to "spin" a good story for the client