Write a pl-sql stored function that takes username as input

Assignment Help Database Management System

Reference no: EM132098935

Please do in Oracle SQL

Create a table UserPermissions (provide create and insert statements code)

Document	UserName
Policy	SYSTEM
Menu	JDOW
W2	USAM
Permissions	SYSTEM
W2	JDOW
Form 1040	USAM
Policy	JDOW
W2	SYSTEM

Write a PL/SQL stored function 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, "User not found".

Sample output:

JDOW can view 3 document(s)

SYSTEM can view 3 document(s)

USAM can view 2 document(s)

Reference no: EM132098935

Questions Cloud

Identify components used in building an IT infrastructure : SBM4104 IT Infrastructure Assignment - Poster. Identify and classify the different components used in building an IT infrastructure

Write a program to simulate processing of a packet : Write a (simple) program to simulate processing of a packet at a router interface with an ACL bound to that interface.

Find the events that led up to the liquidation : ACC701 Accounting Financial Assignment - Discuss all three companies above and find (via electronic journals) the events that led up to the liquidation

Define a complete binary heap : List 5 uses of heaps. Define a d-ary heap. Define a complete binary heap.

Write a pl-sql stored function that takes username as input : Write a PL/SQL stored function that takes username as input and returns number of documents that user has permissions to view.

Determine the total cost of manufacturing : Using the current cost system, determine the total cost of manufacturing one unit of each product and the profit per unit for each product

Create an application that uses the file created by the use : Create an application that uses the file created by the user in Exercise 9a and allows the user to enter an account number to view the account balance.

What are the top two sorting and searching algorithms : What are the top 2 sorting and searching algorithms ? Write a OOP program that store an array of 100 integers.

Write a simple user interface which allows users to create : Write a simple user interface, which allows users to create polygons of the various types, input their geometric dimensions

User Account

All Pages