Data abstraction has been achieved in Oracle by separating the client and the server side logic. Therefore the client applications cannot manipulate the data. The triggers perform content based auditing and selectively disable application updates.
Access control can be achieved in Oracle by allowing the users to manipulate the data by using only their definer’s permitted previledges.
What are roles? How can we implement roles?
Roles in oracle restrict access to the different database objects. They are most useful when there are many database users. Once a role is created it can be granted to a user.
Example:
Create a role:-
Create role select_data;
Grant select on student. Employee, salary to select_data
Grant to a user:
Grant select_data TO John;
Revoke a role:-
Revoke select_date FROM John;
What is user Account in Oracle database?
A user account is given to a user for accessing the database. This user account is used to manage the database. Each account is also given privileges in order to restrict access