You can use views and stored procedures to tailor privileges to suit the needs of your enterprise.
For databases that require a high level of security, there are limitations on defining privileges directly on tables. Any privilege granted to a user on a table applies to the entire table. You may need to assign privileges more precisely than on a table-by-table basis. For example: