Oracle Security - Oracle Security FAQs

Data abstraction has been achieved in Oracle by separating the client and the server side logic...
A role is a set or group of privileges that can be granted to users or another role....
A user account is a schema which is used to store database objects, applications, and components.....
The files that are created when an oracle background process encounters an exception are Trace files......
A tablespace is a logical storage unit within an Oracle database because it is not visible in the file system of the machine, the database resides on.....
Auditing includes reading, writing and deleting the access on the objects at the table level. The privileges granted to a user can be audited....
There are three levels of auditing: Statement level: Statements found in stmt_audit_option_map are audited.....
The steps are : First set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora file, Then dbs$orapwd file=orapw$ORACLE_SID password=sys force=y.....