title: Defining user roles in Database
body: <p>I'm developing a web application which will shared by a few colleges in my city. The cumulative number of clerks and office staffs will be around a <strong>few ten thousands</strong>. </p>
  
  <p>I have created users like 'admission clerk','account staff', etc. and have defined the tables that can be accesses by each user type( say 'admission clerk' can access only admission_table and not payment_table). </p>
  
  <p>I have enforced a programmatic security, where, when an admission clerk of a college logs in, he can <strong>delete an entry in admission_table where student_college field equals admission_clerk organization</strong> . Can I achieve the same by creating users in the dbms ?</p>