assign previleges to users

in my application there are admin,manager and operator who use the application . in the databse i want to give all powers to admin and the manager should be able to read data only. the operator should be able to read and write to db. and i also need to create database roles to these people.

could you please suggest me a solution to do this