Create table and insert data



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

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 and CONTROL privilege to Pat



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

Grant CONTROL privilege on table 'credit_card' to Pat so that he can add security labels to the table columns.