Question: i have an invoice view and a detail table help please in pl/sql 9) make the database more secure by un allowed for any user

i have an invoice view and a detail table help please

i have an invoice view and a detail table

help please

in pl/sql

9) make the database more secure by un allowed for any user to modify(apply dml) invoice master and detail table on specific date e.g. 20-2-2022 by using statement trigger

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

In the year of his death, J owned a rental property land (FMV $250,000; cost $200,000), building FMV $340,000; cost $300,000; UCC $200,000). In his Will, he bequeathed the property to his daughter....

i have an invoice view and a detail table help please (NOTE) THE INVOICE IS A VIEW NOT A TABLE YOU INSERT OR DELETE IN BUT THE DETAIL IS A TABLE in pl/sql 9) make the database more secure by un...

pls use oracle PL/sql command line ------ Q1 ) Create a complete project using SQL/PLSQL program ing language to achieve the following requirement to develop point of sale system which allow the...

Q1 ) Create a complete project using SQL/PLSQL program ing language to achieve the following requirement to develop point of sale system which allow the Employee to add customer invoice which contain...

ATTENTION TUTORS PLEASE HELP ME IN ANSWERING THIS ATTACHMENT WORKSHEET I NEED IT FOR CLASS IN ACCOUNTING THANK YOU HAVE THE ANSWERS IN YELLOW PLEASE SEE ATTACHMENT Question 1 of 15 1. A small...

Project students name & id: 1 - 2 - 3 - 4 - 5 - Q 1 ) Create a complete project using SQL / PLSQL programing language to achieve the following requirement to develop point of sale system which allow...

Please complete the attached worksheet thank you and highlight the answer in yellow see attachment Question 1 of 15 1. A small consulting company wants to make the switch to QuickBooks Online. All of...

I need some assistance with this worksheet Please and Thank you. I JUST NEED THE ANSWERS FOR THEM THANK YOU THEY ARE 5 SECTIONS WITH A TOTAL OF 15 QUESTIONS Question 1 of 15 1. A small consulting...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Please see attached file and answer (1-2 pages) the following questions: - What is the structure of this industry? - Who are the primary players? - What external risks does the industry face? Table...

5a. Put a 1 by the reaction for which AH* = Eact. b. Put a 2 by the reaction for which Eact = 0. c. Put a 3 hy the reaction for which Eact > AH'. Br-Br Br+ Br. (Eact activation energy) H3C-H+ Br H3C...

Listed below are a few events and transactions of Kodax Company. Year 1 January 2 Purchased 8s,000 ahares of Grecco Company comon stock for $491,000 eash. Grecco has 255,000 shares of connon stock...

The fund for which you got the following 5 - factor model results is likely to consists of . . . CoefficientsP - valueIntercept 0 . 0 6 0 . 7 7 Mkt - RF 0 . 8 6 2 . 3 0 E - 1 6 SMB 0 . 6 3 0 . 6 7...

Consider a scenario in which you could personally use present or future value calculations to come to a conclusion. Explain the scenario, and provide calculations that show how you applied the time...

2. Place a value on the outcomes.

4. Obtain an annual amount of benefits (operational results) from training by comparing results after training to results before training (in dollars).

7. Calculate the ROI by dividing benefits (operational results) by costs. The ROI gives an estimate of the dollar return expected from each dollar invested in training.