• A schema is used to collectively identify set objects, the schema can also be used to control permission lists defining access to the collective objects. Users create objects under schemas typically for business separation.

    The database role is more a general gathering of users which can be either granted permission on required objects or granted schema access allowing the schema to do the work.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉