Db-edit - Revision history

Ho at 13:51, 27 October 2012

2012-10-27T13:51:50Z

2012-10-27T13:50:45Z

2012-10-27T13:50:28Z

‎MSSQL Server database properties

2009-07-07T12:48:46Z

‎Connections

2009-07-07T12:46:51Z

‎Oracle database properties

2009-07-07T12:42:30Z

2009-07-07T12:42:16Z

‎MSSQL Server database properties

2009-07-07T12:38:09Z

2009-06-10T21:38:02Z

2008-07-16T22:06:49Z

New page: {{Template:dbsweb}}

New page

@@ Line 11: / Line 11: @@
 * being db_owner in the database, or
 * having at the VIEW DEFINITION grant
 === Oracle database properties ===

@@ Line 9: / Line 9: @@
 The user must have read access to the meta data, either
-- being db_owner in the database, or
+* being db_owner in the database, or
-- having at the VIEW DEFINITION grant
+* having at the VIEW DEFINITION grant
 === Oracle database properties ===

← Older revision		Revision as of 13:50, 27 October 2012
Line 6:		Line 6:

	Server, Catalog, Username and Password must be provided for live database.		Server, Catalog, Username and Password must be provided for live database.
		+
		+	The user must have read access to the meta data, either
		+
		+	- being db_owner in the database, or
		+	- having at the VIEW DEFINITION grant

	=== Oracle database properties ===		=== Oracle database properties ===

← Older revision		Revision as of 12:48, 7 July 2009
Line 25:		Line 25:

	=== Connections ===		=== Connections ===
		+
		+	If all required fields are entered, press the "Test Connection" button to test whether the settings are correct, and dbscript can access the database.
		+
		+	If the connection test succeeds, the "Can Connect" field is checked. Otherwise, an error message is displayed.
		+
		+	Note that the target database is accessed from the web server, not from the client machine.
		+

	[[Category:Database]]		[[Category:Database]]

← Older revision		Revision as of 12:46, 7 July 2009
Line 23:		Line 23:

	[http://devio.wordpress.com/2009/06/10/documenting-oracle-databases/ Documenting Oracle Databases in dbscript]		[http://devio.wordpress.com/2009/06/10/documenting-oracle-databases/ Documenting Oracle Databases in dbscript]
		+
		+	=== Connections ===

	[[Category:Database]]		[[Category:Database]]

@@ Line 1: / Line 1: @@
 {{Template:dbsweb}}
+Display and edit [[Database]] properties.
 === MSSQL Server database properties ===

← Older revision		Revision as of 12:42, 7 July 2009
Line 1:		Line 1:
	{{Template:dbsweb}}		{{Template:dbsweb}}
		+
		+
		+	Edit [[Database]] properties.

	=== MSSQL Server database properties ===		=== MSSQL Server database properties ===

← Older revision		Revision as of 12:38, 7 July 2009
Line 21:		Line 21:

	[http://devio.wordpress.com/2009/06/10/documenting-oracle-databases/ Documenting Oracle Databases in dbscript]		[http://devio.wordpress.com/2009/06/10/documenting-oracle-databases/ Documenting Oracle Databases in dbscript]
		+
		+	[[Category:Database]]

← Older revision		Revision as of 21:38, 10 June 2009
Line 1:		Line 1:
	{{Template:dbsweb}}		{{Template:dbsweb}}
		+
		+	=== MSSQL Server database properties ===
		+
		+	Server, Catalog, Username and Password must be provided for live database.
		+
		+	=== Oracle database properties ===
		+
		+	You can define the Oracle connection in two ways:
		+
		+	* set “Server” to the instance name listed inside tnsnames.ora and leave “Catalog” empty
		+	* set “Server” to server:port, and “Catalog” to the service name (as in tnsnames.ora)
		+
		+	A new field called “Import Options” allows you to define the scope of the schema import:
		+
		+	* “USER” (the default value)
		+	* “ALL:” + list of user names
		+	* “DBA:” + list of user names
		+
		+	The user specified in “Username” needs to have access to the ALL_ and DBA_ catalog views, respectively.
		+
		+	[http://devio.wordpress.com/2009/06/10/documenting-oracle-databases/ Documenting Oracle Databases in dbscript]