Create a login with the following credentials. username: YourName (Ex. Mark), password: pw123. Create another user under
Fantastic news! We've Found the answer you've been seeking!
Question:
- Create a login with the following credentials. username: YourName (Ex. Mark), password: pw123.
- Create another user under the login you have created.
- Create a user-defined role named "udr_YourNickname" with a privilege of viewing and updating the data in the "Items" table.
- Assign the created user-defined role to the user.
- Give the user an access to view, update, and delete data in the "Items" table.
- Remove the role you have assigned to that user.
- Change the access of that user by removing his privilege to delete data in the "Items" table.
Related Book For
Principles Of Information Security
ISBN: 9780357506431
7th Edition
Authors: Michael E. Whitman, Herbert J. Mattord
Posted Date: