Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Policy for creating new databases

Posted on 2003-03-04
Medium Priority
Last Modified: 2013-12-18
Hi all,

Our company is growing large and frequently we have users who are not in IT developing databases only to find out later that they should have used something else or they have duplicated something that already existed.  We haved decided we want to lock everything down so that only IT can create a new db and we will have policies for creating new db's.  I'm not asking how to lock down the server but rather if any of you monkeys have policies of your own that I can steal and tweak for my own use and become the company hero... something to get me started.  So for example the policy will say if you want a database then 1) what do you want it to do? 2) who is it for? 3) does it exist somewhere else etc etc etc.

Anybody doing something like this?


Question by:snocross
  • 2
  • 2

Accepted Solution

AndrewJayPollack earned 200 total points
ID: 8065154
  I've seen this done in a lot of places.  There are some common ideas that should be in your process.  These are an aggragate of some of what I've seen work well.

* There needs to be a small group that is aware of all the applications out there.  That's critical, this becomes the "review group"

* Someone who needs a db should submit the need to the review group.  

* the review group must have  specificly limited time to respond to the user -- a service level agreement if you will -- or else users won't want to comply.  E.G., within 7 days the review group will give you a list of what else is going on in the same space.

* if there is dissagreement between the requestor and the reviewgroup as to the need for the new db, there needs to be a simple, quick, clear set of guidelines for dealing with it.  (i've seen everything from an appeals process to a "you pay for it, you can have it" policy).

* Costs for deploying a database should be determined, so they can be discussed in context, or even passed on to a group.  For example, a db of 1-100mb in size requires "$x" per month for the I.T. group to support.  That way, if a department wants to pay to have something built, the costs of support can be rolled in before management decides to approve it.

* keep your costs down by allowing users to manage the groups themselves (use the author names field to let db managers run the groups in their acl's).

* keep a master db, with a list of all the db's, their owners, and a next review date (is the db still in use?).

Expert Comment

ID: 8065155
Oh yea ! my client has a huge application to do this - IN NOTES !!!

Everything is driven by signed agents and only these agent signer has access to create databases on the server (including development).

So, you use this application to say what is this intended for and stuff like that, and say new database or attach a database from your local. Choose a server and path, this new database will be copied by the Agent (signed by superID) to the server.

Almost all the options are available through this application including updating design from development to production, changing ACLs modifying db properties etc etc...since R5 this tool has become more powerful.


Author Comment

ID: 8065200
This is great stuff guys.  Andrew I think that's what I'm looking for but I'll keep this question open for a bit.  Guys please submit your ideas and maybe I'll post some more points separately... Arun, what is the name of that software you use?  Or was it built internally?


Expert Comment

ID: 8065876
Its built internally... We call it DART - Domino Application Request Tracking :-)

FYI: All the requests in this system are automatically processed unless otherwise specified.  And all requests are processed within 5 minutes Guaranteed ! (except during one time when I broke it ;-) !


Author Comment

ID: 8066171
Ahhh.... DART.... also a Dodge product.  The old Dodge DART.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question