Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 4th, 2005, 06:06 AM
Authorized User
Join Date: Jan 2005
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default Takeover of Administration of Oracle

I have recently joined a local pharmaceutical company as a Manager-MIS

The corporate objective is to outsource the ERP development (which is currently being done in-house costing plenty of time and resources and bringing about no significant productivity but significant problems.. for sure)

The inhouse ERP is being developed on Oracle/Develper 6i

My first job is to carefully take the controle of database administration which is currently in hands of developers (who are definitely aware of what's being done -- outsourcing!!!!)

Can you pls provide me the necessary guideline (Dos & Don'ts)
or a checklist which I can use to ensure transparent transfer of admin controls & development activities from "them" to myself.

As my first step I am planning to freeze the current database status and use visual basic for applications (Excel) to do day-to-day users reporting requirements "on ad hoc basis", in the meantime I will deal with external ERP solution suppliers .

Old August 11th, 2005, 07:48 AM
Authorized User
Join Date: May 2005
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts

Typically when you need to control database administration in ANY relational database environment, you must implement concepts such as ROLES for users, and you should also segregate your development environment from your production and testing environments.

The first step should be to assign someone to become the official DBA of the database. This entity (whether it is one person, or a group) should be trained as an Oracle DBA preferably. This entity should be responsible for DATA INTEGRITY on the database(s) and that should be their primary focus.

The DBA should be responsible for creating and maintaining your development, testing, and production environments, and creating specific roles with specific rights and users assigned to these various roles. Developers should only have access to the development environment, and only those rights on the database that are deemed appropriate. For example, in some installations, DBA's do all table mainenance and creation, and developers must make requests of the DBA for new tables, views, indexes etc. You need to define what rights each specific role on your database has.

Migration of code from development databases to testing and finally production environments should be controlled by the DBA as well, to insure data integrity.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Administration tool question kherrerab ASP.NET 2.0 Professional 0 February 9th, 2007 10:16 AM
Takingover of Administration of Oracle amjad_mahmood Oracle 1 August 5th, 2005 04:29 AM
Administration Site using VWD bmains ASP.NET 1.0 and 1.1 Professional 0 July 19th, 2004 11:20 PM
Getting started on Administration side S Kamran All Other Wrox Books 1 June 26th, 2004 07:24 AM
Creating a sale administration sassenach Classic ASP Databases 1 July 28th, 2003 05:59 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.