Question: Write a SQL statement to un-grant the select and alter privilege from the user Ahmed . Assume that the table name is ' student '

Write a SQL statement to un-grant the select and alter privilege from the user Ahmed.

Assume that the table name is 'student'

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

Q:

sql Question 14 Write a SQL statement to un-grant the select and alter privilege from the user Ahmed. Assume that the table name is 'student

Q:

Question 14 Write a SQL statement to un-grant the select and alter privilege from the user Ahmed. Assume that the table name is 'student' Use the editor to format your

Q:

q13 Points Assume that you have a table Ac that contains two columns: employee name e_name and the salary sal. Write a SQL statement that lists all employees' names and gives each a 15% pay increase...

Q:

EXTERNALLY CREATE USER username IDENTIFIED { BY password GLOBALLY AS 'external name' } [ DEFAULT TABLESPACE tablespace) [ TEMPORARY TABLESPACE { tablespace tablespace_group_name } ] [QUOTA { integer...

Q:

This is all one thing that cannot be broken up. Please help with this one database. Thanks 1. Create a new user (as yourself or favorite movie character) by inserting into the users table. As the...

Q:

This assignment requires you to manipulate tables and data. You will create some SQL objects and write some SQL query statements. First, be sure you run the Northwoods and Clearwater scripts. Next,...

Q:

1. Create the Dormitory table described below enforcing all constraints Add the following three rows to Dormitory 2. Add the following column to the STUDENT table. In the context of this example,...

Q:

Answer the questions below for the table -- Create the petSupplies table drop table if exists petSupplies; CREATE Table IF NOT EXISTS petSupplies ( prodID VARCHAR(50), suppDescription VARCHAR(2000),...

Q:

Please help with this lab assignment - Java Chapter 16 Lab - Databases Lab Objectives Be able to write SQL statements. Be able to retrieve information from a database. Be able to add information to a...

Q:

Write the SQL statement that will list the names of all students who have a faculty advisor with an id of 1 . List the names in the following format the first name, one space, the middle initial, a...

Q:

A bicycle wheel has a small pebble embedded in its tread. The rider sets the bike upside down, and accidentally bumps the wheel, causing the pebble to move through an arc length of 25.0 cm before...

Q:

The compound beam is fixed at A and supported by rockers at B and C. There are hinges (pins) at D and E. Determine the components of reaction at thesupports 15 kN 30 kN - m 6 m 2 m 2 m'2 m

Q:

P18.1 (LO 1, 2, 4) (Three Differences, No Beginning Deferred Taxes, Multiple Rates) The following information is available for Remmers Corporation for 2025. 1. Depreciation reported on the tax return...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

Imagine that the U.S. Congress, recognizing the importance of being well dressed, started giving preferential tax treatment to clothing insurance. Under this new type of insurance, you would pay the...

Q:

Find some information on an index fund (such as the Vanguard Total Stock Market Index, ticker symbol VTSMX). How has this fund performed compared with other stock mutual funds over the past 5 or 10...

Q:

According to an old myth, Native Americans sold the island of Manhattan about 400 years ago for $24. If they had invested this amount at an interest rate of 7 percent per year, how much would they...