In this problem, you should create a view, several roles, and then grant specifickinds of access of the view to the roles.$$ Create a view of the Supplier table in the extended Order Entry Databaseintroduced in the problems section of Chapter $11.$ The view should includeall columns of the Supplier table for suppliers of printer products $($Product$.$ProdName column containing the word $$Printer$).$ Your view should benamed $$PrinterSupplierView$.$ Define three roles: PrinterProductEmp, PrinterProductMgr, and StoreMgr.$$ Grant the following privileges of PrinterSupplierView to PrinterProductEmp:retrieval of all columns except supplier discount.$$ Grant the following privileges of PrinterSupplierView to PrinterProductMgr:retrieval and modification of all columns of PrinterSupplierView exceptsupplier discount.$$ Grant the following privileges of PrinterSupplierView to StoreMgr: retrievalfor all columns, insert, delete, and modification of supplier discount.