nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

allow database modifications

Alan_Forbes_(natsuser3_-_(deleted))

How can I prevent users from getting access to the "allow database modifications" checkbox when creating LiveReports?

Find more posts tagged with

Comments

AFRL_5_Shared_Account_User

Did you ever receive a reply to this question?cora.beimesche@wpafb.af.mil

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

The "Allow database modification" checkbox is a standard feature of LiveReports that cannot be removed without some sort of customization. When checked, it will allow for SQL statements in the LiveReport, such as insert, update, and delete, to execute successfully. This is one of the main reasons that the LiveReport creation privilege is restricted to only the Admin user in a default Livelink installation.

There is a patch that you might be able to obtain from Open Text Global Services (through your sales representative) that does the following:

"...prevents a LiveReport from running any DML (ie insert,update,delete) and DDL (create, alter, drop). "

The issue of LiveReports allowing for the ability to modify the database has been entered under the following bug, the status of which is "Open" and flagged as a suggestion for a future release:

Bug #1991823 - Livereports should never allow "Delete" or "Update" SQL commands

- Bhupinder

------------------------------------------------------
Bhupinder Singh, B.Math., B.Ed.
Senior Product Specialist, Customer Support
Open Text Corporation, Waterloo, Ontario, Canada
Customer support e-mail: support@opentext.com
Customer Support Telephone: 800-540-7292
------------------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, February 15, 2006 12:22 PM
To: eLink Recipient
Subject: Did you ever receive a reply to this question?

Did you ever receive a reply to this question?		Posted by afrluser5 (User, AFRL 5 Shared Account) on 02/15/2006 12:19 PM
In reply to: allow database modifications		Posted by natsuser3 (Forbes, Alan) on 01/10/2006 10:28 AM

Did you ever receive a reply to this question?

cora.beimesche@wpafb.af.mil

Alan_Forbes_(natsuser3_-_(deleted))

Hi BhupinderWe seem to already have the patch installed because no one except Admin can see the "Allow Database Modifications" check box.The problem is that I have recently taken over as LL sys admin and no one here seems to know about the patch.Could you tell me what it is called and where/how it is installed and also if there are any parameters I can alter (for example, allowing certain users like other sys admins to see the checkbox)

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

The patch files are named as follows:

pat21001.txt for Livelink 9.1 SP3

pat21000.txt for Livelink 9.0.0

Unfortunately, there are no configurable parameters.

- Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, February 16, 2006 4:49 AM
To: eLink Recipient
Subject: Allow database modifications

Allow database modifications		Posted by natsuser3 (Forbes, Alan) on 02/16/2006 04:47 AM
In reply to: RE Did you ever receive a reply to this question?		Posted by bsingh (Singh, Bhupinder) on 02/15/2006 01:50 PM

Hi Bhupinder
We seem to already have the patch installed because no one except Admin can see the "Allow Database Modifications" check box.
The problem is that I have recently taken over as LL sys admin and no one here seems to know about the patch.
Could you tell me what it is called and where/how it is installed and also if there are any parameters I can alter (for example, allowing certain users like other sys admins to see the checkbox)

Alan_Forbes_(natsuser3_-_(deleted))

Hi BhupinderOn further investigation it seems that users have been prevented from seeing the relevant section in the create new LiveReport page because it has been commented out of the createlivereport and editlivereport html files.RgsAlan