Question: 2. Write SQL query for the following: (2 Marks) Grant privilege to create table to B 1. Grant privilege to B2 from Bl to do

2. Write SQL query for the following: (2 Marks) Grant privilege to create table to B 1. Grant privilege to B2 from Bl to do select, insert with Grant option

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 Mathematics Questions!

Discretion in Mathematics2 Assume m is a constant positive integer. For an integer c, let Kc = k N | k c (mod m). k Demonstrate that the set Kc is not empty for any c Z. [2 notations] (ii) For an...

Please solve it using SQL Developer: Part A: Create the following tables using SQL Developer, based on the given data types and constraints. Please note that you must study the structure of the...

1. write SQL query to find out Get the top accounts that had the highest amount sold in the month of July 2016 2. write SQL query to find out Get the least accounts that had the least amount sold in...

Submission GuidelinesYou can put your answers in either this document ( after each question ) or a new MS word document ( just your answers ) . You are required to upload the word document to LMS ....

QUESTION 14 Product Table Product Name 715 716 717 718 719 720 721 722 724 725 726 727 728 729 730 731 732 733 735 736 737 738 Long Sleeve Logo Jersey. L Long-Sleeve Logo Jersey, XL HL Road...

Create HR database with the following tables. Write SQL query for the following questions based on above database. No. Question 1. Write a SQL query to find those employees whose salaries are less...

Please I need help with the Part 3 and 4 Questions of this exercise. Thank you. Exercise: Hotel Schema Overview Hotel Software Guild is a resort hotel on the West Arm of Lake Minnetonka. It is a...

Using the BANK database write and execute the following SQL queries: 1. Write a query in SQL to display the customer_name(fname, Iname) whose acc_status is "Active". 2. Write a query in SQL to...

ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...

Write SQL query that shows all the columns in the country table for the North America region. The results need to be sorted in ascending order by population 2. Write SQL query that shows the unique...

The company operates a travel club through which subscribers can access low rates for air fares, hotel rooms, and rental cars. Each year, subscribers pay a refundable fee of $1,000 that allows them...

Jones was engaged to examine the financial statements of Gamma Corporation for the year ended June 30. Having completed an examination of the investment securities, which of the following is the best...

Describa el problema social y explique porque un diseo factorial sera una buena opcin para su investigacin

Oust the Turtle Company has the following balances on December 31, 2020: Cash on hand 4,500.00 Cash in bank A 33,000.00 Cash in bank X 50,000.00 Cash in bank C 822,999.72 Cash on hand includes $ 3....