Question: In AdventureWorks2017Create a user 'yourfirstname' with strong password. Create a role 'Developers'. Add your user to 'Developers' role. Grant select and execute on HumanResources schema

In AdventureWorks2017Create a user 'yourfirstname' with strong password.

Create a role 'Developers'. Add your user to 'Developers' role.

Grant select and execute on HumanResources schema to 'Developers' role and Grant select and execute on HumanResources schema to 'Developers'role.

Write sql query for the above question.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To achieve the requirements you mentioned you can use the following SQL queries in Adven... View full answer

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:

Alton Appliance Service had net income for the year of $32,500. In addition, the balance sheet reports the following balances: (Click the icon to view the balances.) Calculate the return on assets...

Q:

what extent does social capital play a role in facilitating social mobility, and how does it intersect with other forms of capital, such as cultural and economic ?

Q:

THIRD AVENUE SOFTWARE HEALTH-CARE APP PROJECT This case is new for the ninth edition of Information Technology Project Management . The case provides an opportunity to apply agile and Scrum...

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:

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Q:

QUESTION 11 Each of the outcomes listed below is a result of executing the following script except for one. Which one? CREATE ROLE ExampleRole; ALTER ROLE db_datareader ADD MEMBER ExampleRole; GRANT...

Q:

Describe the types of cybercrimes facing organizations and critical infrastructures, explain the motives of cybercriminals, and evaluate the financial Explain both low-tech and high-tech methods...

Q:

\fTable of Contents List of Figures R2 - Internal Competitive Analysis Internal Competitive Analysis of Top Tier Firms The social networking industry is split into two market segments: Consumer and...

Q:

\fTable of Contents List of Figures R2 - Internal Competitive Analysis Internal Competitive Analysis of Top Tier Firms The social networking industry is split into two market segments: Consumer and...

Q:

ITM 309: Business Information Technology and Systems Spring 2016 Watson and the new era of cognitive systems Jerry Haan IBM Cloud Ecosystem Development January 27, 2016 2013 International Business...

Q:

Following are financial statements (historical and forecasted) for the Global Products Corporation. A. Assume that the cash account includes only required cash. Determine the dollar amount of equity...

Q:

This WSJ article provides you with excellent historical perspective of how US financial audit practice have been evolved. This is the designated posting area for your article review based on your...

Q:

Write the Equation in Standard Form: - 9 x ^ 2 - y ^ 2 + 2 y + 8 = 0

Q:

In a congressional district, 55% of registered voters are Democrats. A polling organization selects a random sample of 500 registered voters from this district. Let p = the proportion of Democrats in...

Q:

Show that EQ CFG is co-Turing-recognizable.

Q:

Refer to Exercise 55. Suppose that Gallup wanted to cut the margin of error in half from 3 percentage points to 1.5 percentage points. How should they adjust their sample size? a. Multiply the sample...

Q:

Obtain an expression for F and T e for the two-port resistive matching network shown in Figure A.10, assuming a source at T 0 = 290? K. R1 R2

Q:

Observational studies suggest that moderate use of alcohol by adults reduces heart attacks and that red wine may have special benefits. One reason may be that red wine contains polyphenols,...

Q:

Optimization of product, service, information, and funds flow through integration and collaboration across the value chain, highlighting potential synergies and the impact of enhancing...

Q:

If a subquery is used in the FROM clause of a query, how are the subquerys results referenced in other clauses of the query?

Q:

Change the constraint created in Assignment #6 so that associated rows of the BOOK_STORES table are deleted automatically if a row in the STORE_REPS table is deleted.

Q:

Which of the following commands can you use to modify an index? a. ALTER SESSION b. ALTER TABLE c. MODIFY INDEX d. ALTER INDEX e. None of the above

Q:

Which of the following is a characteristic of stage N3, or slow-wave sleep? a. increased body temperature b. paralysis of voluntary muscles c. increased heart rate d. deepest level of sleep

Q:

Your friend tells you she is seeing a therapist who wishes to use hypnosis as part of her therapy. However, your friend is concerned that she might be hypnotized without knowing it. What might you...

Q:

Michael finds that most of his dreams are little more than random images that seemingly have been put into a strange storyline. Which theory of dreams best explains this? a. activation-synthesis...