Our corporate policy for databases requires us to setup & run Windchill on a non-owner (Oracle) database account, with minimum required privileges,in our PROD environment. As we move towards that, I'm trying to figure out the set of privileges required by Windchill, and anticipate what trouble or other "gotchas" this might lead to.
A brief survey of the manuals and from an initial call to PTC, it would seem this is an unsupported configuration.
Basically, our DBAs want to control access to the database "owner" schema used by Windchill; i.e., allow us to use it for install, but then have us re-point Windchill to use another "user" schema that has grants with just the minimum privileges on the objects created by Windchill in its "owner" schema.
Has anyone tried this? Will this work? Any useful and related references we might read that come to mind?
OurDBAs seem to have a good case when they argue that Windchill <u>must</u> be able to support this, since this is a fairly standard requirement in corporate environments.
Eagerly
