Re: Running ARS in Read-Only mode?

2011-09-29 Thread Axton
You could create a new user, grant select access to all the remedy owned
objects (tables and views), create synonyms for those objects for the new
user, then connect Remedy to the db using the new user.  This would ensure
that Remedy will not update any data.  I've never tested this, but it should
work.  There are some things that Remedy updates behind the scenes like AR
System User Preferences; not sure what the impact to the system is in these
cases.

Axton

On Wed, Sep 28, 2011 at 10:06 PM, Vaibhav Singhal vaibhavsing...@hcl.comwrote:

 **
  Thanks John, Thanks Joe

 I appreciate your suggestion Joe. We already have this in Plan#1 :)
 Planning is in very early stage and we are collecting all possibilities
 and vendor advice.


 Cheers!
 Vaibhav

  --
 *From:* Action Request System discussion list(ARSList) [
 arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza [jdso...@shyle.net]
 *Sent:* Thursday, September 29, 2011 7:57 AM

 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Running ARS in Read-Only mode?

  **

 Vaibhav,

 What would be the purpose of running a system that costs almost an arm and
 a leg and a half to run it in a read only mode? Just curious..

 Wouldn’t just a cheap RDBMS database (like Access) serve the same purpose
 if you just want to store relationship data, to just view it using some type
 of a frontend??

 Even if you want to only report from that instance, it is sufficient to
 mirror the database to a reporting server, and install your reporting tools
 on that server. Personally I don’t see any other reason why you might want a
 read only AR System instance.. If you must have an AR Server instance
 installed there, then what John said will work. But it is a huge overkill
 for reading relational data.. Its like renting a over size U-Haul van for
 the purpose of going to the grocery to buy a dozen X-small chicken eggs..

 Joe

  *From:* John Sundberg john.sundb...@kineticdata.com
 *Sent:* Wednesday, September 28, 2011 7:50 PM
 *Newsgroups:* public.remedy.arsystem.general
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Running ARS in Read-Only mode?

  **
 Make all the licenses - read-only, disable escalations and write a filter
 for submit/modify/merge that produces a no you don't error message.

 -John

 Sent from my iPhone

 On Sep 28, 2011, at 5:54 PM, Vaibhav Singhal vaibhavsing...@hcl.com
 wrote:

   **
  Hi List,

 I wonder if it's possible somehow to Run ARS 6.03, ITSM 6.3 in Read-Only
 mode?


 Thanks for your help.

 Cheers!
 Vaibhav


 --
 ::DISCLAIMER::

 ---

 The contents of this e-mail and any attachment(s) are confidential and
 intended for the named recipient(s) only.
 It shall not attach any liability on the originator or HCL or its
 affiliates. Any views or opinions presented in
 this email are solely those of the author and may not necessarily reflect
 the opinions of HCL or its affiliates.
 Any form of reproduction, dissemination, copying, disclosure, modification,
 distribution and / or publication of
 this message without the prior written consent of the author of this e-mail
 is strictly prohibited. If you have
 received this email in error please delete it and notify the sender
 immediately. Before opening any mail and
 attachments please check them for viruses and defect.


 ---

   _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
  _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Running ARS in Read-Only mode?

2011-09-28 Thread Vaibhav Singhal
**





Hi List,

I wonder ifit's possible somehowto RunARS 6.03,ITSM 6.3in Read-Only mode?


Thanks for your help.

Cheers!
Vaibhav




::DISCLAIMER::
---

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender immediately. Before opening any mail and
attachments please check them for viruses and defect.

---



_attend WWRUG11 www.wwrug.com  ARSlist: "Where the Answers Are"_


Re: Running ARS in Read-Only mode?

2011-09-28 Thread John Sundberg
Make all the licenses - read-only, disable escalations and write a filter for 
submit/modify/merge that produces a no you don't error message.

-John

Sent from my iPhone

On Sep 28, 2011, at 5:54 PM, Vaibhav Singhal vaibhavsing...@hcl.com wrote:

 **
 Hi List,
  
 I wonder if it's possible somehow to Run ARS 6.03, ITSM 6.3 in Read-Only mode?
  
  
 Thanks for your help.
  
 Cheers!
 Vaibhav
  
 
 ::DISCLAIMER::
 ---
 
 The contents of this e-mail and any attachment(s) are confidential and 
 intended for the named recipient(s) only.
 It shall not attach any liability on the originator or HCL or its affiliates. 
 Any views or opinions presented in
 this email are solely those of the author and may not necessarily reflect the 
 opinions of HCL or its affiliates.
 Any form of reproduction, dissemination, copying, disclosure, modification, 
 distribution and / or publication of
 this message without the prior written consent of the author of this e-mail 
 is strictly prohibited. If you have
 received this email in error please delete it and notify the sender 
 immediately. Before opening any mail and
 attachments please check them for viruses and defect.
 
 ---
 _attend WWRUG11 www.wwrug.com  ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: Running ARS in Read-Only mode?

2011-09-28 Thread Joe Martin D'Souza

Vaibhav,

What would be the purpose of running a system that costs almost an arm and a 
leg and a half to run it in a read only mode? Just curious..

Wouldn’t just a cheap RDBMS database (like Access) serve the same purpose if 
you just want to store relationship data, to just view it using some type of a 
frontend??

Even if you want to only report from that instance, it is sufficient to mirror 
the database to a reporting server, and install your reporting tools on that 
server. Personally I don’t see any other reason why you might want a read only 
AR System instance.. If you must have an AR Server instance installed there, 
then what John said will work. But it is a huge overkill for reading relational 
data.. Its like renting a over size U-Haul van for the purpose of going to the 
grocery to buy a dozen X-small chicken eggs..

Joe

From: John Sundberg 
Sent: Wednesday, September 28, 2011 7:50 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: Running ARS in Read-Only mode?

** 
Make all the licenses - read-only, disable escalations and write a filter for 
submit/modify/merge that produces a no you don't error message.

-John

Sent from my iPhone

On Sep 28, 2011, at 5:54 PM, Vaibhav Singhal vaibhavsing...@hcl.com wrote:


  ** 
  Hi List,

  I wonder if it's possible somehow to Run ARS 6.03, ITSM 6.3 in Read-Only mode?


  Thanks for your help.

  Cheers!
  Vaibhav



--
  ::DISCLAIMER::
  
---

  The contents of this e-mail and any attachment(s) are confidential and 
intended for the named recipient(s) only.
  It shall not attach any liability on the originator or HCL or its affiliates. 
Any views or opinions presented in
  this email are solely those of the author and may not necessarily reflect the 
opinions of HCL or its affiliates.
  Any form of reproduction, dissemination, copying, disclosure, modification, 
distribution and / or publication of
  this message without the prior written consent of the author of this e-mail 
is strictly prohibited. If you have
  received this email in error please delete it and notify the sender 
immediately. Before opening any mail and
  attachments please check them for viruses and defect.

  
---

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Re: Running ARS in Read-Only mode?

2011-09-28 Thread Vaibhav Singhal
**



Thanks John, Thanks Joe

I appreciate your suggestion Joe. Wealready have thisinPlan#1 :)
Planning is in very early stage and we are collecting all possibilities andvendor advice.


Cheers!
Vaibhav



From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza [jdso...@shyle.net]
Sent: Thursday, September 29, 2011 7:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Running ARS in Read-Only mode?



**



Vaibhav,

What would be the purpose of running a system that costs almost an arm and a leg and a half to run it in a read only mode? Just curious..

Wouldn’t just a cheap RDBMS database (like Access) serve the same purpose if you just want to store relationship data, to just view it using some type of a frontend??

Even if you want to only report from that instance, it is sufficient to mirror the database to a reporting server, and install your reporting tools on that server. Personally I don’t see any other reason why you might want a read only AR System instance..
 If you must have an AR Server instance installed there, then what John said will work. But it is a huge overkill for reading relational data.. Its like renting a over size U-Haul van for the purpose of going to the grocery to buy a dozen X-small chicken eggs..

Joe




From: 
John Sundberg 
Sent: Wednesday, September 28, 2011 7:50 PM
Newsgroups: public.remedy.arsystem.general
To: 
arslist@ARSLIST.ORG 
Subject: Re: Running ARS in Read-Only mode?





**
Make all the licenses - read-only, disable escalations and write a filter for submit/modify/merge that produces a no you don't error message.

-John

Sent from my iPhone

On Sep 28, 2011, at 5:54 PM, Vaibhav Singhal vaibhavsing...@hcl.com wrote:




**


Hi List,

I wonder if it's possible somehow to Run ARS 6.03, ITSM 6.3 in Read-Only mode?


Thanks for your help.

Cheers!
Vaibhav




::DISCLAIMER::
---

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender immediately. Before opening any mail and
attachments please check them for viruses and defect.

---




_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 



_attend WWRUG11 www.wwrug.com  ARSlist: "Where the Answers Are"_