Question: Select all the correct statements about GRANT sql command GRANT cannot mix granting both privileges and roles in the same statement Stored routines privileges can

Select all the correct statements about GRANT sql command
GRANT cannot mix granting both privileges and roles in the same statement
Stored routines privileges can not be managed by GRANT
When using GRANT Without ON Clause, the statement grants roles.
When using GRANT with ON Clause, the statement grants privileges.
GRANT does not support access control on columns
GRANT can not grant more than one privilege in each grant command

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:

State whether each of the following statements is correct or incorrect 1 - V GRANT cannot mix granting both privileges and roles in the same statement 2 - V GRANT can not grant more than one...

Q:

LAB CCIT - 5 1 3 Let's see some examples for the better understanding of this concept. For the demonstration of this particular topic I will use two users HULK and BATMAN which I created during my...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

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:

1. (TCO 1) According to the book, a database system is essentially a high-powered way to manage _____. (Points : 4) people numbers lists of information SQL Question 2. 2. (TCO 1) Which of the...

Q:

I need som help with this sql project. In this exercise, you will create two users and a role. You will grant privileges directly to the first user, but you will grant privileges to the second user...

Q:

I need som help with this sql project. In this exercise, you will create two users and a role. You will grant privileges directly to the first user, but you will grant privileges to the second user...

Q:

ifting. Backw Chapter 1 - Introduction to Taxation s where buy HousesT of notbouboual ; Finds with numer CHAPTER 1: SELF-TEST EXERCISES the distribut Discussion Questions fting. 1. Define taxation....

Q:

What will answer for the below question. Qn 1 : - - - - - - - database link or PL / SQL subprograms in the schema can use this link to access database objects in the corresponding remote database. 1...

Q:

Water at 35C with a velocity of 0.05 m/s flows over a horizontal, 50-mm-diameter cylinder maintained at a uniform surface temperature of 20C. Do you anticipate that heat transfer by free convection...

Q:

How does tomato juice make skunk smell go away?

Q:

11-2 Pennzoil-Quaker State and the Sale of Receivables Pennzoil-Quaker State (PQS) is one of the worlds leading producers of motor oil. The company sells some of its receivables through a special...

Q:

AM 0 4

Q:

Within the White-Collar Occupations, where do Females have the strongest and weakest representations in the Federal Service?

Q:

What are the Five Phases of SDLC? Explain each briefly.

Q:

How can Change Control Procedures manage Project Creep?