RE: [Emerald] StartPrintJob in PrintCustom caused an Error: SQL Server Error

Emerald ( (no email) )
Mon, 2 Aug 1999 13:09:42 -0400

> There is a problem with users in the EmeraldSecur group printing. They
> do NOT have access to the base tables (like MasterAccounts, SubAccounts,
> Invoices, etc) by default, which cause the reports to fail. The only
> workarounds are to allow them select access to those tables they need to
> run the reports against, or modify the invoices to use the views
> (vMasterAccounts, vSubAccounts, etc) and make sure they have the
> modified
> reports locally.

I'm not sure what you mean by "select" access. I gave them global access
/ALL and they still can't print. So I'm assuming this "select" access is
something in SQL server but looking at the security stuff there I don't see
anything called "select".

Can you give me a hint?

Geo.

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart