Configuring SQL Server 2005/2008/2012/2014 Database for Auditing (Release 9.2.2)

To configure SQL Server 2005, 2008, 2012, or 2014 database server for use with EnterpriseOne table auditing, you must set up the privileges described in this section.

1. Log in to the SQL Server 2005, 2008, 2012, or 2014 database server as the sa user (as the administrative user).

2. Run the following SQL commands if you want to enable auditing in the production path code:

   use [JDE_PRODUCTION]

   GO

   GRANT ALTER TO [PRODDTA]

   GO

   use [JDE_PRODUCTION]

   GO

   GRANT CREATE TABLE TO [PRODDTA]

   GO

   use [JDE_PRODUCTION]

   GO

   GRANT CREATE VIEW TO [PRODDTA]

   GO

   use [JDE_PRODUCTION]

   GO

   GRANT ALTER ANY DATABASE DDL TRIGGER TO [PRODDTA]

   GO

3. For every additional path code you want to enable auditing, run the above SQL commands using the database name and database user name that applies to that path code.