Revoke the privilege to delete rows in the ORDERS and ORDERITEMS tables from the CUSTOMERREP role.
Question:
Revoke the privilege to delete rows in the ORDERS and ORDERITEMS tables from the CUSTOMERREP role.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 86% (22 reviews)
REVOKE delete ON ...View the full answer
Answered By
Somshukla Chakraborty
I have a teaching experience of more than 4 years by now in diverse subjects like History,Geography,Political Science,Sociology,Business Enterprise,Economics,Environmental Management etc.I teach students from classes 9-12 and undergraduate students.I boards I handle are IB,IGCSE, state boards,ICSE, CBSE.I am passionate about teaching.Full satisfaction of the students is my main goal.
I have completed my graduation and master's in history from Jadavpur University Kolkata,India in 2012 and I have completed my B.Ed from the same University in 2013. I have taught in a reputed school of Kolkata (subjects-History,Geography,Civics,Political Science) from 2014-2016.I worked as a guest lecturer of history in a college of Kolkata for 2 years teaching students of 1st ,2nd and 3rd year. I taught Ancient and Modern Indian history there.I have taught in another school in Mohali,Punjab teaching students from classes 9-12.Presently I am working as an online tutor with concept tutors,Bangalore,India(Carve Niche Pvt.Ltd.) for the last 1year and also have been appointed as an online history tutor by Course Hero(California,U.S) and Vidyalai.com(Chennai,India).
4.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
Using an account with the required privileges, create a role named CUSTOMERREP that allows inserting new rows in the ORDERS and ORDERITEMS tables and deleting rows from these tables.
-
Delete the CUSTOMERREP role from the Oracle 12c database.
-
What happens if you revoke an object privilege that was granted with the WITH GRANT OPTION? What if the privilege is removed from a user who had granted the same object privilege to three other users?
-
A lightweight, rigid beam 10.0 m long is supported by a cable attached to a spring of force constant k = 8.25 kN/m as shown in Figure P12.38. When no load is hung on the beam (Fg = 0), the length L...
-
Blue Dingo uses a standard costing system. The company's standard costs and variances for direct materials, direct labor, and factory overhead for the month of May are as follows. Determine the...
-
Refer to Exercise 13.41. a. Test for lack of fit of the model b. Write the complete model for this experimental situation. In exercise Machine Speed (rev/min) Wear 100 120 140 160 180 200 23.0,...
-
How do you model multi-phase system operations?
-
Jones Co. is in a technology-intensive industry. Recently, one of its competitors introduced a new product with technology that might render obsolete some of Joness inventory. The accounting staff...
-
You placed $3,502 in a savings account today that earns an annual interest rate of 7 percent compounded annually. How much you will have in this account at the end of 5 years? Assume that all...
-
Dippin Donuts has six bakers and a bakery supervisor on each of its two shifts. Bakers working from 8am 5pm (with a 1-hour break) are paid $6.00 per hour. Bakers working the 10pm-7am shift (with a...
-
Log in to Oracle 12c with the new account created in Assignment 1. Determine the privileges currently available to the account.
-
Remove the CUSTOMERREP role from the account created in Assignment 1.
-
To move forward, a helicopter pilot tilts the helicopter forward. If the rotor generates a force of 3200 lb, with a horizontal component (thrust) of 420 lb, what is the vertical component (lift)?
-
Choose a brand and evaluate its channel plan (where the brand engages with the target audience). What conclusions could you draw about the fit of the channel?
-
What are the primary motives that drive social media participation?
-
What is social publishing? What kinds of content can be published socially?
-
Describe the differences among activity metrics, interaction metrics, and return metrics.
-
What are two compiler switches that help us prevent undefined program behavior?
-
Shell-and-tube heat exchangers with hundreds of tubes housed in a shell are commonly used in practice for heat transfer between two fluids. Such a heat exchanger used in an active solar hot-water...
-
Using Gauss-Jordan elimination, invert this matrix ONLY 0 0 0 0 1
-
Equation 1.1 gives a formula for the end-to-end delay of sending one packet of length L over N links of transmission rate R. Generalize this formula for sending P such packets back-to-back over the N...
-
Why are standards important for protocols?
-
List six access technologies. Classify each one as home access, enterprise access, or wide-area wireless access.
-
A typical optic fiber has a thickness of only 6.00 x 10 nm. Consider a beam from a standard He-Ne laser that has a wavelength equal to 633 nm. Suppose this beam is incident upon two parallel slits...
-
What annual interest rate, r, is required to return $670 from $300 over 10 years? Give your answer as a percentage to two decimal places and assume growth compounds quarterly.
-
Collisions and elasticity In this problem, we'll analyze a one-dimensional collision between a car and a truck. You may find it helpful to use the elasticity parameter k, which is given by: = V1f-V2f...
Study smarter with the SolutionInn App