What is difference between stored procedures and function

Assignment Help Management Information Sys
Reference no: EM131238496

Written Assignment Stored Procedures as a Security Measure

In our readings we have learned the importance of connections and the use of stored procedures and functions. For this assignment we will look at stored procedure and function methods related to securing connections and data in the database.

Note: Don't forget your Oracle 11g documentation resource for the how to examples.

For this assignment you are required to do BOTH Part A and Part B

Part A

Submit short answers thatdiscuss the following questions:

1. What are the advantages of using stored procedures and functions in Oracle?

2. Oracle automatically tracks all object interdependencies for every PL/SQL stored object. What does this include? When does Oracle automatically recompile a stored procedure?

3. What is gained when using stored procedures in a client/server environment? What is the difference between stored procedures and function? When you create a procedure or function, you may define parameters. What types of parameters can be declared?

Lab Password Policy

Your task is to develop a single SQL script that will perform all the following tasks of enforcing password complexity:

1. Connect to SYS user.

2. Create a password complexity function (named as "is481_password") to enforce the following requirements so that the password

? Is at least six (6) characters long

? Differs from the user name

? Has at least one alpha, one numeric, and one punctuation mark character

? Is not simple or obvious, such as welcome, account , oracle, database , or user.

? Differs from the previous password by at least 3 characters

Please note the exact spelling on the function name is REQIRED.

Please note the double quotation mark (") was not a part of the specified function name.

3. Create a profile named is481_prof with the following specifications. Please note the exact spelling on the profile is REQIRED. Test your code before submission.

Number of days the password is valid before it is aged out.

60 days

Number of days ahead of expiration the user is warned about the password expiration.

1 day

Number of days before a password can be reused.

30 days

Number of times a password can be reused.

UNLIMITED

Number of failed login tries allowed before the account is locked.

3

Number of days an account is locked due to failed login tries

13 days

PASSWORD_VERIFY_FUNCTION

is481_password

4. Assign the above profile to user DBSEC that you have already created. (15 points)

Tips:

1. One SQL(PL/SQL) file is required to complete all the above tasks.

3. Typical syntax on connecting to SYS is: "conn sys/password as sysdba;"

Reference no: EM131238496

Questions Cloud

Find the back pressure that will cause subsonic flow : The inlet stagnation state is 1 MPa, 600 K. Find the back pressure that will cause subsonic flow throughout the entire nozzle with M = 1 at the throat. What is the mass flow rate?
Find exit pressure and temperature for supersonic exit flow : Find the exit pressure and temperature for supersonic exit flow to exist in the nozzle flow of Problem 15.47.
Find the mass flow rate when half of mass has been discharge : Air is expanded in a nozzle from a stagnation state of 2 MPa, 600 K, to a back pressure of 1.9 MPa. If the exit cross-sectional area is 0.003 m2, find the mass flow rate.
Estimate the proportion of all adult americans : Estimate the proportion of all adult Americans who felt global warming is a very serious problem at the 95 percent confidence interval.
What is difference between stored procedures and function : What is gained when using stored procedures in a client/server environment? What is the difference between stored procedures and function? When you create a procedure or function, you may define parameters. What types of parameters can be declared..
Calculate the throat and exit areas for the nozzle : Air is expanded in a nozzle from a stagnation state of 2 MPa, 600 K, to a static pressure of 200 kPa. The mass flow rate through the nozzle is 5 kg/s. Assume the flow is reversible and adiabatic and determine the throat and exit areas for the nozz..
Direction of the alternative hypothesis : State the direction of the alternative hypothesis used to test the advertised claim. Type gt (greater than), ge (greater than or equal to), lt (less than), le (less than or equal to) or ne (not equal to) as appropriate in the box.
Find the mach number and the stagnation temperature : The speed of sound in liquid water at 25?C is about 1500 m/s. Find the stagnation pressure and temperature for a M = 0.1 flow at 25?C, 100 kPa. Is it possible to get a significant Mach number flow of liquid water?
State the direction of the alternative hypothesis : State the direction of the alternative hypothesis used to test the taskforce claim. Type gt (greater than), ge (greater than or equal to), lt (less than), le (less than or equal to) or ne (not equal to) as appropriate in the box.

Reviews

Write a Review

 

Management Information Sys Questions & Answers

  Calculate a percentage score for each student

MIS301 - Fall 2016 - You have been offered an internship in the School of Management and the Dean has asked you to fix problems with inconsistent data and grading criteria among the different sections of a GMU class over a period of several years.

  Find recent online article related to business intelligence

Find a recent online article related to a business intelligence topic. In your own words write a summary of the article. As you write your summary consider how your article relates to topics covered in the textbooks, videos, and presentations.

  Describe potential risks to the information

Describe potential risks to the information and the related vulnerabilities within the organization when utilizing web components. How could you mitigate the risk

  Write about the negative aspects of social computing

Prepare a Power Point, Discussion Points to lead/engage the audiance, and a 2 page paper, summarizing the points All about The negative aspects of Social Computing

  Information technology - analog and digital signals

Information Technology - Analog and Digital Signals and difference between analog and digital signals. Provide an example of a digital signal and an analog signal. Which type are you more likely to encounter? Why?

  Examine the structured analysis and design technique

Examine the Structured Analysis and Design Technique (SADT) diagrams that were used to document the reengineered parts of the exam scheduling and distribution process

  How its e-commerce or erp implementation integrated

Illustrate how its e-commerce or ERP implementation integrated with related ICT (information and communication technologies- data mining, business intelligences, data ware house, databases, internet, RFID, VAN, EDI)?

  Describe the similarities and difference of the ehr code set

Describe the similarities and differences of the EHR code sets

  Reply to supply chain managementsupply chain management scm

reply to supply chain managementsupply chain management scm has been a popular buzzword since the mid 1990s and has had

  Important information about hr information systemsthere are

important information about hr information systemsthere are many hr information systems hris out on the market. there

  Discuss computer viruses spread via email or by other

discuss computer viruses spread via email or by other methods. what negative consequences can they have on an

  Advantages and disadvantages of any solution employed

Considering the shared data is extremely sensitive and must be top secret at all costs, formulate a possible solution with consideration to symmetric or asymmetric cryptography and describe the advantages and disadvantages of any solution employed

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd