isrjournals
User Sign in    Editor Sign in

sql query analyze and security precaution tutorial for entry-level database administrators

Rajesh.M,

Published in International Journal of Advanced Research in Computer Science Engineering and Information Technology

ISSN: 2321-3337          Impact Factor:1.521         Volume:4         Issue:2         Year: 05 March,2015         Pages:375-383

International Journal of Advanced Research in Computer Science Engineering and Information Technology

Abstract

Oracle database is known worldwide as a secure and reliable database to maintain organization data. So many organizations prefer Oracle DBA to administrate their database. A junior Database Administrator would face many challenges in handling Oracle database administration activities. For reducing these difficulties, this proposed system provides various level of warning messages and securing precaution techniques, which are to be done before executing DBA level SQL commands. Essentially most of the fresher DBA's are aware about Administration queries but may not be cognizant about affecting environments and indirect security problems belonging to it. So, DBA can Perform Admin level SQL queries to proposed SQL Query analyze and security precaution tutorial (SQL-QASPT) System, and based on the query, it will give warning message and secure configuration techniques for the DBA to consider before performing Administrative operations.

Kewords

warning message, precaution techniques, QASPT, DBA, tutorial.

Reference

[1]. Oracle Database 10g: Administration Workshop I volume I student guide, Edition 3.1 August 2010 [2].Oracle Database 10g: Administration Workshop I volume II student guide, Edition 3.1 August 2010 [3]. Oracle Database 10g: Administration Workshop II volume I student guide, Edition 3.1 August 2010 [4]. Oracle Database 10g: Administration Workshop II volume II student guide, Edition 3.1 August 2010 [5]. Ron Ben-Natan, “Implementing Database Security and Auditing: A Guide for DBAs, Information Security Administrators and Auditors”, Published by Elsevier, 2005. [6]. Sam R Alapati, “Expert Oracle 10g/11g Administration”, Dreamtech Press,First Edition, 2009. [7]. Splitting Method: http://www.dotnetperls.com/split (accessed January 2015) [8]. Splitting Method: http://www.dotnetperls.com/split-vbnet (accessed January 2015) [9].o7_dictionary_accessibility: http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams134.htm#REFRN10133 (accessed February 2015) [10].Flashback Technology: http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_flashback.htm#g1026131 (accessed by December 2014) [11]. Database Administrator guide, Database Link:http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_flashback.htm#g1026131 (accessed January 2015)