I've got permissions to some of my Remedy SQL views to allow for real-time
external reporting via Crystal Reports and the web. The problem I'm having
is that these permissions are randomly dropped and nobody can see the view.
When I say random, it can happen a couple times in a day or not for 2 weeks.
I'm running 4.0.1 on NT with SQL 7.0 backend. I had the same problem with
Remedy 3.2 and SQL 6.5. It only happens on Remedy Views. I have other
databases on the same SQL server that don't experience this problem.

Any ideas?

Tray Marsh
Splitrock Services, Inc.

---------------------------------------------------------------------------
To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
with a body of "unsubscribe arslist". The subject line is ignored.

If you add or drop a field on a schema/form, any permissions granted outside of
Remedy may be dropped and will have to be re-added. I haven't figured out all
the conditions which cause this to occur. Moving fields or changing
permissions doesn't seem to affect external permissions, though. Good luck.




ARSLIST@LISTSERV.ACSU.BUFFALO.EDU on 05/11/99 08:44:24
Please respond to ARSLIST@LISTSERV.ACSU.BUFFALO.EDU @ INTERNET


To: ARSLIST@LISTSERV.ACSU.BUFFALO.EDU @ INTERNET
cc:

Subject: SQL Permissions

I've got permissions to some of my Remedy SQL views to allow for real-time
external reporting via Crystal Reports and the web. The problem I'm having
is that these permissions are randomly dropped and nobody can see the view.
When I say random, it can happen a couple times in a day or not for 2 weeks.
I'm running 4.0.1 on NT with SQL 7.0 backend. I had the same problem with
Remedy 3.2 and SQL 6.5. It only happens on Remedy Views. I have other
databases on the same SQL server that don't experience this problem.

Any ideas?

Tray Marsh
Splitrock Services, Inc.

---------------------------------------------------------------------------
To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
with a body of "unsubscribe arslist". The subject line is ignored.

---------------------------------------------------------------------------
To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
with a body of "unsubscribe arslist". The subject line is ignored.

Tray,

If you modify the permissions at the database level, they will be reset by the ARS server the next time the view is recreated. Views are recreated when you add/delete a field in the form. Also in SQL Server, when you modify a small character field length to be more than 255 characters, or diminishing a long character field to 255 characters or less. This is due because character fields whose length is more than 255 character fields are stored as a text column, so the actual type of the column is changed. This will cause the view to be recreated too.

I don't believe it has something to do with the version of ARS or the database, and as you mentioned, this problem happened with previous versions of ARS and the database. You should do some tests, such as when adding/deleting/modifying character fields and see if the view permissions are reset. You can also probably check out the transaction logs for the SQL server to see exactly at what time these permissions were reset.

Guillaume Rheault
Venimex Consulting Services
http://www.venimex.com
(515) 557-7827

-----Original Message-----
From: Tray Marsh [SMTP:Tmarsh@SPLITROCK.NET]
Sent: Tuesday, May 11, 1999 7:43 AM
To: ARSLIST@LISTSERV.ACSU.BUFFALO.EDU
Subject: SQL Permissions

I've got permissions to some of my Remedy SQL views to allow for real-time
external reporting via Crystal Reports and the web. The problem I'm having
is that these permissions are randomly dropped and nobody can see the view.
When I say random, it can happen a couple times in a day or not for 2 weeks.
I'm running 4.0.1 on NT with SQL 7.0 backend. I had the same problem with
Remedy 3.2 and SQL 6.5. It only happens on Remedy Views. I have other
databases on the same SQL server that don't experience this problem.

Any ideas?

Tray Marsh
Splitrock Services, Inc.

---------------------------------------------------------------------------
To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
with a body of "unsubscribe arslist". The subject line is ignored.

---------------------------------------------------------------------------
To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
with a body of "unsubscribe arslist". The subject line is ignored.