Topic Options
Rate This Topic
#6702 - 05/11/99 08:43 AM SQL Permissions
Anonymous
Unregistered


I've got permissions to some of my Remedy SQL views to allow for real-time
<br>external reporting via Crystal Reports and the web. The problem I'm having
<br>is that these permissions are randomly dropped and nobody can see the view.
<br>When I say random, it can happen a couple times in a day or not for 2 weeks.
<br>I'm running 4.0.1 on NT with SQL 7.0 backend. I had the same problem with
<br>Remedy 3.2 and SQL 6.5. It only happens on Remedy Views. I have other
<br>databases on the same SQL server that don't experience this problem.
<br>
<br>Any ideas?
<br>
<br>Tray Marsh
<br>Splitrock Services, Inc.
<br>
<br>---------------------------------------------------------------------------
<br>To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
<br>with a body of "unsubscribe arslist". The subject line is ignored.
<br>
<br><br>

Top
#6703 - 05/11/99 09:51 AM Re: SQL Permissions [Re: Anonymous]
Anonymous
Unregistered


If you add or drop a field on a schema/form, any permissions granted outside of
<br>Remedy may be dropped and will have to be re-added. I haven't figured out all
<br>the conditions which cause this to occur. Moving fields or changing
<br>permissions doesn't seem to affect external permissions, though. Good luck.
<br>
<br>
<br>
<br>
<br>ARSLIST@LISTSERV.ACSU.BUFFALO.EDU on 05/11/99 08:44:24
<br>Please respond to ARSLIST@LISTSERV.ACSU.BUFFALO.EDU @ INTERNET
<br>
<br>
<br>To: ARSLIST@LISTSERV.ACSU.BUFFALO.EDU @ INTERNET
<br>cc:
<br>
<br>Subject: SQL Permissions
<br>
<br>I've got permissions to some of my Remedy SQL views to allow for real-time
<br>external reporting via Crystal Reports and the web. The problem I'm having
<br>is that these permissions are randomly dropped and nobody can see the view.
<br>When I say random, it can happen a couple times in a day or not for 2 weeks.
<br>I'm running 4.0.1 on NT with SQL 7.0 backend. I had the same problem with
<br>Remedy 3.2 and SQL 6.5. It only happens on Remedy Views. I have other
<br>databases on the same SQL server that don't experience this problem.
<br>
<br>Any ideas?
<br>
<br>Tray Marsh
<br>Splitrock Services, Inc.
<br>
<br>---------------------------------------------------------------------------
<br>To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
<br>with a body of "unsubscribe arslist". The subject line is ignored.
<br>
<br>---------------------------------------------------------------------------
<br>To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
<br>with a body of "unsubscribe arslist". The subject line is ignored.
<br>
<br><br>

Top
#6704 - 06/12/01 11:02 AM Re: SQL Permissions [Re: Anonymous]
Anonymous
Unregistered


Tray,
<br>
<br>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.
<br>
<br>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.
<br>
<br>Guillaume Rheault
<br>Venimex Consulting Services
<br>http://www.venimex.com
<br>(515) 557-7827
<br>
<br>-----Original Message-----
<br>From: Tray Marsh [SMTP:Tmarsh@SPLITROCK.NET]
<br>Sent: Tuesday, May 11, 1999 7:43 AM
<br>To: ARSLIST@LISTSERV.ACSU.BUFFALO.EDU
<br>Subject: SQL Permissions
<br>
<br>I've got permissions to some of my Remedy SQL views to allow for real-time
<br>external reporting via Crystal Reports and the web. The problem I'm having
<br>is that these permissions are randomly dropped and nobody can see the view.
<br>When I say random, it can happen a couple times in a day or not for 2 weeks.
<br>I'm running 4.0.1 on NT with SQL 7.0 backend. I had the same problem with
<br>Remedy 3.2 and SQL 6.5. It only happens on Remedy Views. I have other
<br>databases on the same SQL server that don't experience this problem.
<br>
<br>Any ideas?
<br>
<br>Tray Marsh
<br>Splitrock Services, Inc.
<br>
<br>---------------------------------------------------------------------------
<br>To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
<br>with a body of "unsubscribe arslist". The subject line is ignored.
<br>
<br>---------------------------------------------------------------------------
<br>To unsubscribe from this list, send mail to listserv@listserv.buffalo.edu
<br>with a body of "unsubscribe arslist". The subject line is ignored.
<br>
<br><br>

Top


Moderator:  Matt Reinfeldt