× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Vaibhav Laddha
vaibhavladdha271(*) reported 2014-02-18T05:10:55Z  · NielsGron last modified 2014-06-23T17:34:13Z

Unable to grant execute permissions for procedure in Alter user window


Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - Visual Editing
Version Future - 0.1

Aqua Data Studio 15.0.0-dev-114
Build #: 36113
Built on: 2014-Feb-16 07:56:20 AM     

Database: Informix 12.1

Operating environment:Windows 7 x64

Connect to Informix

Create a table named customer

Create table script:

CREATE TABLE informix.customer  ( 
customer_num SERIAL NOT NULL,
fname       CHAR(15),
lname       CHAR(15),
company     CHAR(20),
address1     CHAR(20),
address2     CHAR(20),
city         CHAR(15),
state       CHAR(2),
zipcode     CHAR(5),
phone       CHAR(18),
PRIMARY KEY(customer_num)
ENABLED
)
LOCK MODE PAGE
GO
 
Create a procedure named 'read_address'
Create procedure script:
CREATE PROCEDURE informix.read_address(lastname CHAR(15))
RETURNING CHAR(15),CHAR(15);
 
DEFINE p_lname,p_fname CHAR(15);
 
SELECT fname,lname INTO p_fname,p_lname FROM customer WHERE lname = lastname;
 
RETURN p_fname, p_lname;
END PROCEDURE
GO
 
Create a user named dbuser
Create user script:
GRANT CONNECT TO dbuser
GO
GRANT RESOURCE TO dbuser
GO
GRANT DBA TO dbuser
GO
 
Right click on created user
Select Alter user
Click on object permission button
Select Procedures from Permissions for object field
Grant execute permissions to procedure
Click on Alter button
 
It gives an error message:"Routine (informix.read_address) can not be resolved."
 
Same happens for functions also

 

1 attachment
  •  
  •  
  • No shares
  •  
All Comments (0) Change History
Sort 

Issue #11721
Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017