Solution-Write a script in sql that creates four login ids

Write a script in sql that creates four login ids

Assignment Help Computer Engineering

Reference no: EM132213319

Question :

Write a script in SQL that creates four login IDs based on the contents of a new table called NewLogins.

CREATE TABLE NewLogins
(LoginName varchar(128))
INSERT NewLogins
VALUES ('BBrown'), ('CChaplin'), ('DDyer'), ('EEbbers')

Use dynamic SQL and a cursor to perform four actions for each row in this table: (1) create a login with a temporary password based on the first four letters of the login name followed by "99999"; (2) set the default database to the AP database; (3) create a user for the login with the same name as the login; and (4) assign the user to the PaymentEntry role.

Reference no: EM132213319

Questions Cloud

Calculate the product of the odd integers from 1 to n : Write a script that will calculate the product of the odd integers from 1 to n (or from 1 to n-1 if n is even, where n is some integer > 3).

What is the importance of auditing : What is the importance of auditing to the accounting profession and the business community? What is the effects of technology to the future of the profession?

The result set should have one row for each vendor : The result set should have one row for each vendor whose contact has the same first name as another vendor's contact. Sort the final result set by Name.

How the tax savings allow hospitals to absorb difference : Our readings discuss how the tax savings allow hospitals to absorb the difference between the cost of care as opposed to the reimbursed costs from patients

Write a script in sql that creates four login ids : Create a login with a temporary password based on the first four letters of the login name followed by "99999";

Prepare a memo for the board of directors : You are the financial director of Company ABC Ltd, a company listed on the JSE. You have been tasked with investigating the viability of a takeover of a company

Display the source code in an editor : The user can supply the directory of choice as an argument; if missing, prompt the user to enter one from the command line.

Determine the proper manner of reporting the assets : In 2010, the No-slice Golf Company decided to augment their very successful line of golf clubs with a new line of professional caliber golf balls.

Display the results in an html table : Write a script to simulate the rolling of two dice. The script should use Math.random to roll the first die and again to roll the second die.

User Account

All Pages

Write a script in sql that creates four login ids

Reference no: EM132213319

Reference no: EM132213319

Questions Cloud

Reviews

Write a Review

Computer Engineering Questions & Answers

Write a program that maintains a database of telephone book

Group of data elements that describes a single entity

Prepare a method to multiply two n times n matrices

Create a flash movie that uses motion animation

Questiondescribe what java environment would contain to do

Define what is the downside of digital medical records

Returns the distance between two points on the plane

What are the two most significant families of operating

Define the pre-scalar and post-scalar values

Describe generalization of the euler tour traversal to trees

What are advantages and disadvantages of fiber-optic cable

Questionmatlab user defined function bedford fowlerwrite

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT