Create a new table - ASSIGNMENT1 . Includes steps to create this table. The table has one
Fantastic news! We've Found the answer you've been seeking!
Question:
- Create a new table - ASSIGNMENT1. Includes steps to create this table.
- The table has one column - COLUMNA and 100 rows.
- Create a script to insert rows into ASSIGNMENT1 table. There needs to be several rows which have a text string beginning with the letter 'A', several rows beginning with the letter 'M' and several rows beginning with the letter 'Z'.
- Provides a 'select * from ASSIGNMENT1' showing the contents of your new table
- Create three new users: USERA, USERB, USERC
- Include a screen shot of the scripts used to create this user.
- Create five roles. RL_READONLY, RL_TBLACCESS, RL_ROWA_READ, RL_ROWM_READ and RL_ROWZ_READ.
- Include a screen shot of the scripts used to create these roles.
- When creating each role, give each ROLE their correct privileges. For example, RL_READONLY should only be granted the 'select' privilege on ASSIGNMENT1.
- Create the security access rules for your new table (at both the table level and the row level access) -- DO NOT use views to implement this. This link will provide details on to set up the 'security policies' for row-level access -- https://docs.oracle.com/database/121/DBSEG/vpd.htm#DBSEG007
Read through the details related to using Oracle's row level security options chose the one you feel supports the following business requirement. Be sure to indicate the 'choice' you have made (e.g. VPD, Label security or Data Redaction) -- Note, if you feel you need to 'alter' your table - ASSIGNMENT1 feel free to do so.
- Provide each of the three new users with the appropriate privileges that allow the following access:
- Read-only access to ASSIGNMENT1
- USERA can only see rows in ASSIGNMENT1 which have values in columnA which begin with 'A'
- USERB can only see rows in ASSIGNMENT1 which have values in columnA which begin with 'M'
- USERC can only see rows in ASSIGNMENT1 which have values in columnA which begin with 'Z'
- Setup Database Audit. Includes the steps to setup the database audit in Oracle (refer to link in the resource section above).
- Use scripts to implement the audit. DO NOT use the menu options.
- You will test to make sure changes are being added to the log.
- Create a new table with one or two columns
- Insert five rows into the table.
- Delete one row from the table.
- Update one row.
- Select one row.
- Use a different row for each of the statements (e, f and g)
- Query the log showing the transactions and screenshot/paste the audio log
Related Book For
Intermediate Accounting
ISBN: 978-1260481952
10th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas
Posted Date: