What is difference between stored procedures and function

Assignment Help Management Information Sys

Reference no: EM131232066

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.

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;"

Submission Requirement:

The SQL script file and the screen capture of your creation will be required for full credit.

Reference no: EM131232066

Questions Cloud

What are some of the reasons for our inability : There are many situations in which we cannot determine exactly what will happen, but we can predict what will happen. What are some of the reasons for our inability to determine exactly what will happen?

Calculate the value of vo1 : Figure shows two CMOS inverters in cascade. - Circuit can be thought of as an uncoupled CMOS R/S flip flop.- calculate the value of vO1.

Connection between the observed outcomes and probabilities : In probabilistic models, the probabilities are always considered to be known. However, in one experiment we may observe the outcomes but not the corresponding probabilities. What is the connection between the observed outcomes and assigned probabi..

How has wireless technology changed your quality of life : Write a 700-word summary of your selected article on wireless technology. Be sure to also address the following: How has wireless technology changed your quality of life or your work environment

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..

Determine the state of the outputs for various input signals : Consider the circuit in Figure. - Determine the state of the outputs for various input signals. - What is the purpose of the input signal φ?

Create a pie chart for your business income and spending : Create a business budget sheet using Microsoft Excel. In the budget sheet, do the following: Create a label called "Income" and add your monthly business income in the next cell: $25,000. Create a pie chart for your business income and spending

What hardware support is required to implement this feature : What is the copy-on-write feature, and under what circumstances is its use beneficial? What hardware support is required to implement this feature?

Explain the operation of the circuit : Explain the operation of the circuit. Is this a positive- or negative-edge-triggered flip- flop? - Redesign the circuit to make this a static flip-flop.

User Account

All Pages