snocross
asked on
Policy for creating new databases
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?
Thanks!
-Snocross
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?
Thanks!
-Snocross
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
-Patrick
-Patrick
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 ;-) !
:-)
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 ;-) !
:-)
ASKER
Ahhh.... DART.... also a Dodge product. The old Dodge DART.
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.
-Arun.