revoke execute rights form procedures ifx_replace_

Posted in 2015

Topics: Security, Permissions & Auditing, Data Types & Schema Design

ABRAR RASHID — Wed, 10 Jun 2015 09:47:13 — source: IIUG Forums & Mailing Lists

Hi, I want to revoke execute rights from public from 'ifx_replace_module' function . I am executing following statement but got error of "Routine (ifx_replace_module) ambiguous - more than one routine resolves to given signature. " revoke execute on ifx_replace_module from public as informix;---Routine (ifx_replace_module) ambiguous - more than one routine resolves to given signature. After adding parameters in revoke command i am getting syntax error. revoke execute on ifx_replace_module(varchar,varchar,varchar,varchar) frompublic as informix; revoke execute on ifx_replace_module(varchar,varchar,varchar) from public asinformix; ---- 201: A syntax error has occurred. Kindly help me to resolve this issue.

↪ replying to ABRAR RASHID

John Miller — Wed, 10 Jun 2015 09:59:53 — source: IIUG Forums & Mailing Lists

I believe you must tell indicate if this is a routine, procedure or function. Try the statement below. revoke execute on function ifx=5Freplace=5Fmodule(varchar,varchar,varchar,varchar) from public as informix; John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 06/10/2015 02:47:14 AM: > From: "ABRAR RASHID" <mabrar@i2cinc.com> > To: ids@iiug.org > Date: 06/10/2015 02:47 AM > Subject: revoke execute rights form procedures ifx=5Freplace=5F [35250] > Sent by: ids-bounces@iiug.org > > Hi, > > I want to revoke execute rights from public from > 'ifx=5Freplace=5Fmodule' function > .. > > I am executing following statement but got error of "Routine > (ifx=5Freplace=5Fmodule) ambiguous - more than one routine resolves to gi= ven > signature. > " > > revoke execute on ifx=5Freplace=5Fmodule from public as informix;> ---Routine (ifx=5Freplace=5Fmodule) ambiguous - more than one routine resolves to > given signature. > > After adding parameters in revoke command i am getting syntax error. > > revoke execute on ifx=5Freplace=5Fmodule(varchar,varchar,varchar,varchar) from > public as informix; > revoke execute on ifx=5Freplace=5Fmodule(varchar,varchar,varchar) from pu=blic as > informix; > ---- 201: A syntax error has occurred. > > Kindly help me to resolve this issue. > > > ***************************************************************************= **** > Forum Note: Use "Reply" to post a response in the discussion forum. >