Question: can you write me a script that can identify which object, database and job a user owns in a server?? i want one full script

can you write me a script that can identify which object, database and job a user owns in a server?? i want one full script not a separate script.
#sql server #database

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:

can you write me a script to to identify what each user own in a database?? like what object, job and database they own. i want one script not separate script for object , job and database. one...

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:

TABLES FOR THE ASSIGNMENT CREATE TABLE CustomerService.Reps ( RepID int IDENTITY(1,1), CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID), BusinessEntityID int not null, CONSTRAINT FK_BusinessEntityID...

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:

Mr. Om was very pleased with the work you did for him last week and wants you to retrieve a few more reports for him. He has also recommended you to work for his friend, Mr. Bok who owns a small...

Q:

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

Q:

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

Q:

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

can you please write me a sql script that identify which user owns object , database or job in a database. i want one script not separate. #sql server #database

Q:

On January 1, Year 1, PAR Ltd. invested $10 in cash for a 10percent interest in VIC Inc. An analysis has been performed, and it has been determined that VIC is a variable interest entity and PAR is...

Q:

How did the Sarbanes-Oxley Act attempt to reduce fraudulent reporting by addressing opportunity, incentives, and character?

Q:

3 1 A company has outstanding 3 million shares of $ 2 par common stock and 1 miltion shares of $ 4 par preferred stock. The preferred stock has an 8 $ dividend rate The company declares $ 3 0 0 , 0 0...

Q:

Multiple Choice Question What aspect of New Media art adds digital information to real - time life? Augmented reality Hyperrealism Parg - Para Ecosystem

Q:

What penalty (if any) should Foster receive?

Q:

=+1. What is the schedule for this project?

Q:

Assume that you assigned to examine labour relations at the Travellers Inn. Review the material for Johnson, and briefly summarize your major findings.