Create a procedure called droplogins

Assignment Help Database Management System

Reference no: EM131473934

Question: 1. Create a procedure called "dropLogins". In this procedure, include the following code

Declare @Roles Table(DbRole varchar(20), MemberName varchar(50), MemberSID varchar(50));

insert into @Roles EXEC sp_HelpRoleMemberCustomerRole

The procedure sp_HelpRoleMember returns a table of users for the CustomerRole (see note below). The table is then inserted into a table variable called @Roles.

Declare a cursor for "select MemberName from @Roles" where MemberName has all the logins. Using the cursor and dynamic SQL, drop the member from the CustomerRole, drop the user and then drop the login.

Reference no: EM131473934

Questions Cloud

Develop your programming and problem solving skills : The objective of this assignment is to develop your programming and problem solving skills in a step-by-step manner, assisted with visualization.

What is current value : What is current value of $1,000 bond with 4% coupon rate and 4% comparable rate of interest if it matures after 10 years.

What are the annual cca deductions : What are the annual CCA deductions associated with this equipment for the first five years?

Write essay on contemporary issues in business communication : You are required to write an essay on: "Contemporary issues in professional business communication."

Create a procedure called droplogins : Create a procedure called "dropLogins". In this procedure, include the following code Declare @Roles Table(DbRole varchar(20), MemberName varchar(50), MemberSID

Create advertising and public relations objectives : Create advertising and public relations objectives that align to each one of the bank's strategic goals.

Comparable rate of interest : What is current value of $1,000 bond with 4% coupon rate and 4% comparable rate of interest if it matures after 10 years. Please show work.

Spherical marginal corporate tax rate : This equipment has a CCA rate of 25% and Spherical's marginal corporate tax rate is 35%.

What is meant by accelerating the process : What is meant by "accelerating the process"?What is the marketing objective for the growth stage of the product life cycle?

User Account

All Pages