Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Which of the following sequences of statements would ensure that Jerry has the privileges of the roles of sales and associate? CREATE ROLE associate NOINHERIT;

Which of the following sequences of statements would ensure that Jerry has the privileges of the roles of sales and associate?
CREATE ROLE associate NOINHERIT;
CREATE ROLE sales INHERIT;
GRANT sales to jerry;
GRANT associate to sales;
CREATE ROLE associate NOINHERIT;
CREATE ROLE sales NOINHERIT;
GRANT associate to jerry;
GRANT associate to sales;
CREATE ROLE associate INHERIT;
CREATE ROLE sales INHERIT;
GRANT sales to jerry;
GRANT associate to jerry;
CREATE ROLE associate NOINHERIT;
CREATE ROLE sales NOINHERIT;
GRANT sales to jerry;
GRANT associate to sales;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual Basic 2017 For Windows Web And Database Applications

Authors: Corinne Hoisington

1st Edition

1337102113, 978-1337102117

More Books

Students also viewed these Databases questions

Question

How many multiples of 4 are there between 10 and 250?

Answered: 1 week ago

Question

2. What type of team would you recommend?

Answered: 1 week ago