Write a script that creates four login IDs based on the contents of a new table

Question

Write a script that creates four login IDs based on the contents of a new table called NewLogins. Use dynamic SQL to perform three 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"9999"; (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 you created in exercise 1.

Create TABLE NewLogins

(LoginName varchar (128))

INSERT NewLogins

VALUES ('BBrown'), ('CChaplin'), ('DDyer'), ('EEbbers')

http://imgur.com/kfa6jox,UQtkXsK#0 image one is the database and the next image is the answer to number one.

Explanation / Answer

http://docs.oracle.com/cd/A97630_01/appdev.920/a96590/adg13trg.htm

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.