-
What are the use of Roles ?
REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges for a group of related users granted to a role and then grant only the role to each member of the group. DYNAMIC PRIVILEGE MANAGEMENT - When the privileges of a group must...
-
What are the different Levels of Auditing ?
Statement Auditing, Privilege Auditing and Object Auditing.
-
What is user Account in Oracle database?
An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges.
-
How will you enforce security using stored procedures?
Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.
-
What is a trace file and how is it created ?
Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.
-
What are roles? How can we implement roles ?
Roles are the easiest way to grant and manage common privileges needed by different groups of database users. Creating roles and assigning provides to roles. Assign each role to group of users. This will simplify the job of assigning privileges to individual users.
-
How can we specify the Archived log file name format and destination?
By setting the following values in init.ora file. LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc (%S - Log sequence number and is zero left paded, %s - Log sequence number not padded. %T - Thread number lef-zero-paded and %t - Thread number not padded). The file name created is arch 0001 are if %S is used.LOG_ARCHIVE_DEST = path.
-
What is the use of ANALYZE command ?
To perform one of these function on an index,table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary. - To delete statistics about the object used by object from the data dictionary. - To validate the structure of the object. - To identify migrated and chained rows of the table or cluster.
-
-
Features of Database Vault
What are the features of Database Vault? Can you restrict the sessions with MAC address?
-
What are the roles and user accounts created automatically with the database?
DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary are store in this schema and are manipulated only by ORACLE. SYSTEM user account - It has all the system privileges for the database and additional tables and views ...
prakashpichika
- Oct 4th, 2006
&DBSNMPSupports Oracle SNMP (Simple Network Management Protocol). The Oracle Intelligent Agent requires a database logon for each SID that it manages. By default this account is called "DBSNMP" CheersRavi Prakashhttp://ravidba-oracle.blogspot.com/
-
What are the minimum parameters should exist in the parameter file (init.ora) ?
DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control file while database creation. DB_DOMAIN - It is string that specifies the network domain where the database is created. The global ...
-
-
What do you mean by Database Security?
prakashpichika
- Oct 3rd, 2006
Database Security is a group of related things...in which the Oracle Database hardening is Must to make the Database secure.Some of them are1)OS server should be a single function system dedicated to ...
-
What's the Advantage if Listener logging is enabled?
prakashpichika
- Oct 3rd, 2006
Force attempts are not stopped by the Listener but it can log them if logging is enabled. set LOGGING_LISTENER=ONCheersRavi Prakashhttp://ravidba-oracle.blogspot.com/
-
What is Tablespace Quota ?
The collective amount of disk space available to the objects in a schema on a particular tablespace.
-
What are the system resources that can be controlled through Profile ?
The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE made by a SQL statement the amount of logical I/O available to the user's session the amout of logical I/O available to a single call to ORACLE made by a SQL statement...
-
What is Statement Auditing ?
Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.
srinivasanram2004
- Jul 25th, 2008
The Statement auditing is tracking the SQL statements issued by database users. In order to enable or disable auditing on SQL statements, you must have the AUDIT SYSTEM privilege.
-
What is Privilege Auditing ?
Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
srinivasanram2004
- Jul 25th, 2008
Privilege auditing involves the tracking of the SQL statements issued by users who have been granted the right to execute that statement through a system privilege. In order to enable or disable audit...
-
What is Object Auditing ?
Object auditing is the auditing of accesses to specific schema objects without regard to user.
srinivasanram2004
- Jul 25th, 2008
Object auditing involves the tracking of the specific SQL DML statements issued against objects by database users.
Oracle security Interview Questions
Ans