Question
( SQL Developer) Create a table UserPermissions (provide create and insert statements code) (5 points for the correct code of the procedure and 3 points
( SQL Developer) Create a table UserPermissions (provide create and insert statements code) (5 points for the correct code of the procedure and 3 points for testing your function; one point per test case). Do not modify table or column names.
Document | UserName |
Policy | SYSTEM |
Menu | JDOW |
W2 | USAM |
Permissions | SYSTEM |
W2 | JDOW |
Form 1040 | USAM |
Policy | JDOW |
W2 | SYSTEM |
Write a PL/SQL stored procedure that takes username as input and returns number of documents that user has permissions to view. If username is not in the table, your procedure should return: "no documents for USERNAME".
Include code that can be copied and ran, and screenshots of the results. Do not forget to test "user not found" case.
Sample output: set serveroutput on: exec p vies ('PAUL' exec p vieus('SYSTE: Script Output x > Query Result x 4 Task completed in 0.02 seconds PROCEDURE P VIEWS compiled anonymous block completed no documents for PAUL anonymous block completed three documents) for SYSTEH
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started