Oracle Database 11 G
Abstract
Oracle Database 11 g is a comprehensive platform database, there are many features of the Oracle product that support different kinds of companies worldwide. This writing assignment will present an overview of some Oracle features. More specifically this paper will focus on the main features of oracle database administration, like security, indexing constraints and views.
Basic user security
Security refers to activities and measures to ensure the confidentiality, integrity, and availability of an information system and its main asset, data. (Coronel, 2010). Database security consists of the mechanisms that protect the database against intentional or accidental threats. Security considerations apply not only to the data held in a database but security breaches can affect other parts of the system. Database security takes into consideration hardware, software, users and the data. To effectively implement security requires appropriate controls, which are defined in specific mission objective. This need for security, while often having been neglected or overlooked in the past , is now increasingly recognized by organizations. The reason for this turnaround is the increasing amounts of crucial corporate data being stored on computer and the acceptance that any loss or unavailability of this data could prove to be disastrous. . ( Connolly, 2005).
Oracle, like the rest of the computer industry, has provided a large sampling of security settings for the database. The basic levels of security break down to account, access, and system level security. To access a database, a user must run a database application and connect to the database instance using a valid user name defined in the database. For Oracle, the creation of a new user with password authentication must be set. Whenever the user attempts to connect to the database, this user will be presented with a Connect or Log On dialog box, prompting for a user name and password to access the
Oracle Database 11 g is a comprehensive platform database, there are many features of the Oracle product that support different kinds of companies worldwide. This writing assignment will present an overview of some Oracle features. More specifically this paper will focus on the main features of oracle database administration, like security, indexing constraints and views.
Basic user security
Security refers to activities and measures to ensure the confidentiality, integrity, and availability of an information system and its main asset, data. (Coronel, 2010). Database security consists of the mechanisms that protect the database against intentional or accidental threats. Security considerations apply not only to the data held in a database but security breaches can affect other parts of the system. Database security takes into consideration hardware, software, users and the data. To effectively implement security requires appropriate controls, which are defined in specific mission objective. This need for security, while often having been neglected or overlooked in the past , is now increasingly recognized by organizations. The reason for this turnaround is the increasing amounts of crucial corporate data being stored on computer and the acceptance that any loss or unavailability of this data could prove to be disastrous. . ( Connolly, 2005).
Oracle, like the rest of the computer industry, has provided a large sampling of security settings for the database. The basic levels of security break down to account, access, and system level security. To access a database, a user must run a database application and connect to the database instance using a valid user name defined in the database. For Oracle, the creation of a new user with password authentication must be set. Whenever the user attempts to connect to the database, this user will be presented with a Connect or Log On dialog box, prompting for a user name and password to access the
References: Casteel, J. (2009) Oracle 11g SQL. Connolly, T. & Begg, C. (2005). Database Systems: A Practical Approach to Design, Implementation, and Management. (4th ed.). Coronel, C., Morris, S. & Rob, P. (2010). Database Systems: Design, Implementation and Management (9th ed.). Murray, M. (2010). Database Security: What Students Need to Know. Journal of Information Technology Education: Innovations in Practice. Vol 9. Kuhn, D. (2010). Pro Oracle Database 11g Administration Oracle: Database Administrator 's Guide 11g Release 1 (11.1). (2008). Retrieved from http://docs.oracle.com/cd/B28359_01/server.111/b28310.pdf Oracle: Performance Tuning Guide 11g Release 1 (11.1). (2008). Retrieved from http://docs.oracle.com/cd/B28359_01/server.111/b28274.pdf Taylor, C. (2003). An Introduction to Metadata. Retrieved from http://www.library.uq.edu.au/iad/ctmeta4.html Stellato, E. (2012). The Benefits of Indexing Foreign Keys. Retrieved from http://www.sqlperformance.com/2012/11/t-sql-queries/benefits-indexing-foreign-keys