user stauts from sql table then redirect him

Question

i have a web application using c# and sql database, i want after log in user check weather his role is allowed to access any page of application. in sql table i have id ,pages where i give url of that page role_id,and access type which is bool datatype, if admin make this 0 then user will not allow to access that page.