Warning: ksort() expects parameter 1 to be array, object given in /home/coreyha/gistlibrary.org/wp-content/plugins/bbpress/includes/core/template-functions.php on line 316
SQL user permissions required for GIST tables « Getting It System Toolkit

SQL user permissions required for GIST tables

We have recently added important information to the Acquisitions Manager Installation Guide. After installing the GIST tables to your SQL server, you need to also grant Select, Insert, Update, and Delete privileges to the ‘illiad’ SQL user on each new table. You can do this individually or by using the following query in SQL Server Management Studio:

Use ILLData

go

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTWeb] TO [illiad]

GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTFunds] TO [illiad]

GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTHistory] TO [illiad]

GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTFundLink] TO [illiad]

GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTInvoice] TO [illiad]

GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTVendor] TO [illiad]

GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTConspectus] TO [illiad]

GO

We hope to release a new SQL script soon that will automatically assign these privileges for new Acquisitions Manager users. If you have already installed these tables, please follow the directions above.

Also note that we listed minimum system requirements for using the Acquisitions Manager and GIST for ILLiad Webpages. As explained in the ILLiad 8.1 release notes, prior versions of ILLiad will be unable to access third-party tables. This includes the GIST tables needed for the Acquisitions Manager. Please update your server and clients to the latest versions of ILLiad before implementing the Acquisitions Manager or GIST for ILLiad Webpages. This will also ensure that the ILLiad client is able to properly handle the GIST ILLiad Addons.

Tags: ,

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>