Explain briefly what is meant by Schema in the context of ...

[faduma]

Explain briefly what is meant by Schema in the context of database security, and how you might include it in a security plan.
 
  What will be an ideal response?

Question 2

Explain how you would use roles in setting up a database security system.
 
  What will be an ideal response?

[kjohnson]

Answer to Question 1

In the context of database security, schema refers to the ownership of database objects. Users can be assigned to a schema much as they can be assigned to a role. Then permissions can be granted on the objects of the schema. The effect is much the same as using a role. In addition, schema can be assigned to roles, so that a role can contain both permissions and ownership of objects.

Answer to Question 2

Assigning permissions to individual users can be complex and hard to maintain. Roles allow you to create sets of related permissions that usually map to the ways various users work with the database. For example, a Human Resources role would contain all the permissions that those working in that department would need. Users can be dropped from or added to a role without needing to change the permissions.

[faduma]

Thank you

[kjohnson]

No problemo