What are the minimal set of Microsoft SQL permissions the database user needs in order to be able to do all one needs for the end users of SBM? For information about Oracle permissions, see KB S133641 .
If an invalid database name or connection is provided at login or has been mis-typed from various clients, the connection would appear to hang or not respond. This could also block connections from other clients while we are attempting to connect to the database.
This is usually caused by the Oracle schema user used by the Application Engine database having been assigned the "ANY" privilege ( In this case having the "Select Any Sequence" permission will cause this issue with Work Center and Request Center ). See this kb doc S133641 for more information about proper roles and privileges for an Oracle schema user but if that user has the "ANY" privilege then revoke that privilege . After revoking it restart JBoss and try logging into Workcenter again to verify you see content.
After a new installation when trying to connect to Dimensions user gets a normal error saying cannot connect to dimensions please check database connection is correct and oracle is running After putting on the trace, user gets the following in the trace
