Write a pl-sql stored function that takes username

Assignment Help Database Management System

Reference no: EM132135936

IN SQL DEVELOPER

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

Reference no: EM132135936

Questions Cloud

Perform a sql injection attack in the search for users box : Your task is to now perform a SQL Injection attack in the "Search for users" box such that it prints out all the usernames and passwords.

What is the set of possible values of variable x : A coin is flipped five times in an experiment. If x is the number of heads that turn out in the experiment, what is the set of possible values of variable x?

What is the df value for the t statistic for study : An independent-measures study has one sample with n = 10 and a second sample with n = 15 to compare two experimental treatments

Dogs weight and how long the dog lived : The following is data a veterinarian collected from some of her clients. it is a rough estimate % of dogs weight and how long the dog lived

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

Confidence interval for the population mean : Use the standard normal distribution or the? t-distribution to construct a 90?% confidence interval for the population mean. Justify your decision. If neither d

Confidence intervals for the population mean : A random sample of the closing stock prices in dollars for a company in a recent year is listed below.

Sample from an unknown population : A researcher conducts a hypothesis test using a sample from an unknown population. If the t statistic has df = 35, how many individuals were in the sample?

What datatypes can they work with : SQL uses relational and logical operators in the WHERE clause to restrict the rows returned in a query.

User Account

All Pages