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.....
|