Question: can you write me a script to identify what objects each user owns in a database . what object , database and jobs they owns

can you write me a script to identify what objects each user owns in a database . what object , database and jobs they owns .
#sqlserver #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 identify what object each user owns in a database? what object, job and database ?? #sqlserver #database

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:

can you write me a script to identify what object, database or job a user owns in a server?? i want one script everything in one script . #sqlserver #database

Q:

can you write me a script to identify what object , database and jobs each user owns in a sql server . #sql server #database #script

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:

these are the querys CREATE OR REPLACE FUNCTION status_desc_sf (p_stage IN NUMBER) RETURN VARCHAR2 IS lv_stage_txt VARCHAR2(30); BEGIN IF p_stage = 1 THEN lv_stage_txt := 'Order Submitted'; ELSIF...

Q:

Please, this assignment is about Database integration, we have worked on html web page creation where we create html web pages, then we move on to the MVC application with servlet and JSP, then...

Q:

Phone,type,area code,prefix,suffix (3) the class must be able to read a file (ask the user for the name of the file) and somehow return an ArrayList. This ArrayList can then be passed to your...

Q:

I need help with my Computer Science 2 project. Develop a high-quality, menu-driven object-oriented C++ program that creates a small database, using a binary search tree structure to store and...

Q:

I need help with my Computer Science 2 project. Develop a high-quality, menu-driven object-oriented C++ program that creates a small database, using a binary search tree structure to store and...

Q:

You are the mechanical engineer in charge of maintaining the machines in a factory. The plant manager has asked you to evaluate a proposal to replace the current machines with new ones. The old and...

Q:

Fox Corporation had the following stockholders' equity amounts on January 1, 2022: Preferred Stock, 5%, $40 par, 30,000 shares authorized, 10,000 shares issued and outstanding, cumulative,...

Q:

Tito Company reported the following information relating to liabilities on December 31, 20Y1: Accounts payable for goods and services purchased on open account amounted to P600,000 and accrued...

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

5. List your five favorite TV shows. What do they have in common? Are these the same top five that your friends would list? Why or why not? What is it specifically that you like about these shows?...

Q:

6. Practice five skills for becoming a more mindful and media literate consumer

Q:

4. Think of a controversial issue about which you have very strong opinions. Write one paragraph describing the key problem and its main causes, taking care to present your information as objectively...