Issues that are important:
System security
System integrity
Data security
Data access
Why security is important:
same as above- to control access to information
How should you manage secuirty/permissions:
system privileges- gain access to the database
object privileges - manipulate the content of database objects, such as views, tables, procedures
schema - collection of objects(tables, sequences and views)
using roles(--named group of related privileges that can be granted to the user- a user can have access to several roles or several users can be assigned to the same role) helps to control the access to specific db tables. Using roles can allow users the controlled ability to view only, make and commit changes or update only.
I hope this answer helped you. If it has, please click the
ACCEPT button.
Let me know if you have additional questions!