-- 1. Create users Ashton, Kelly, and James (you can use password test1234) -- 2. Write the...
Fantastic news! We've Found the answer you've been seeking!
Question:
-- 1. Create users Ashton, Kelly, and James (you can use password test1234)
-- 2. Write the commands to grant the following privileges: -- a. User Ashton must be able to retrieve data from the PART table. -- b. Users Kelly must be able to add new orders and order lines, but can only read from the other tables -- c. User James must be able to change the price for all parts. -- e. All users must be able to retrieve each customer's number, name, street, city, state, and zip code. -- f. Revoke all privileges from user Ashton.
Related Book For
Principles Of Information Security
ISBN: 9780357506431
7th Edition
Authors: Michael E. Whitman, Herbert J. Mattord
Posted Date: