Setup authority and tables for the workshop



You must log into the database as the database creator before proceeding with this page.


Create table and insert data



Run the SQL on the right to create the table and populate with data. You may receive create table error if the required tables were already created in the previous tutorial.


Grant SECADM authority to Pat



Grant SECADM authority to Pat because he is the security administrator of the superstore.

Grant CONTROL privilege on 'dailysales' table to user Pat so that he can grant/revoke privileges to/from other users.