Schemas In The Db. How To Keep Right Way

We have several schemas in the database. We need 3 roles read, readwrite and execute. Can anyone to advice me the best way to set up roles for security reason. All schemas we can group it or we can keep it same way

Please provide more details about what you are trying to do. Which database vendor are you using? How do you want to use this information?

-M