Version Differences for Database Permissions

Revision as of 25 February 2013 10:36 (→Imported Databases Note) ← Previous diff

Revision as of 11 March 2013 14:56 m (→Installation w/Oracle XE) Next diff →

Line 5:
	= Installation w/Oracle XE =		= Installation w/Oracle XE =
-	Connect as SYSTEM, and then create a new user. Grant '''RESOURCE''' and '''CONNECT''' on that user (you should now be able to access this connection through ''SQL-DEVELOPER''). Now, you should be able to install anthillpro (NOT as DBA user) with the new user.	+	Connect as SYSTEM, and then create a new user. Grant '''RESOURCE''', '''CONNECT''', '''CREATE SESSION''', and '''CREATE TABLE''' on that user (you should now be able to access this connection through ''SQL-DEVELOPER''). Now, you should be able to install anthillpro (NOT as DBA user) with the new user.
	See the [http://wiki.urbancode.com/AnthillPro/Comments:Database_Permissions talk] page for further details.		See the [http://wiki.urbancode.com/AnthillPro/Comments:Database_Permissions talk] page for further details.
		+	''NOTE: Do <u>NOT</u> use '''GRANT ALL''' as this will cause '''AmbiguousTableNameExceptions!'''''