Security SQL from Afternoon Class

select * from Person

Create login bob with password='password'
use Community_Assist
Create user bobuser for login bob
Create role grantapplicationrole
Grant select, insert on GrantRequest to grantapplicationRole
Grant exec on usp_Register to grantapplicationrole
Grant exec on usp_login to grantApplicationrole
Grant select on GrantType to grantApplicationrole
alter role grantApplicationrole add member bobuser