Write the appropriate SQLs to implement the following; Create and verify a role called Vendor $\_$Role with a password. This role shall be granted all possible privileges in Customer, Vendor, and Product. For this role to work you shall enable this role and run a check to make sure it is enabled. This is to be assigned to an account, you have created and verified, called John$\_$Smith whose password is Congo$37.$ John$\_$ Smith must also be assigned a profile with $3$ concurrent session, $30$ minutes inactive time and $5$ consecutive failed login attempts. Show all appropriate SQLs$.$