× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Vaibhav Laddha
vaibhavladdha271(*) reported 2014-02-12T11:08:32Z  · NielsGron last modified 2014-06-24T18:33:00Z

statement separator is not generated for revoke statement in roles in informix


Dev
Ivan Gron
ivangron
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Q Analyzer
Version Future - 0.1

Aqua Data Studio 15.0.0-dev-96
Build #: 35893
Built on: 2014-Feb-06 02:45:16 PM

Database: Informix 12.1

Operating environment:Windows 7 x64

Create a user named 'dbuser'

Create user script:

 
REVOKE role1 FROM dbuser
GO
REVOKE DBA FROM dbuser
GO
REVOKE RESOURCE FROM dbuser
GO
REVOKE CONNECT FROM dbuser
GO
GRANT CONNECT TO dbuser
GO
GRANT RESOURCE TO dbuser
GO
GRANT DBA TO dbuser
GO
GRANT role1 TO dbuser
GO
 

Create a role named 'role1'

Create role script:

CREATE ROLE role1
GO
GRANT role1 TO dbuser
GO
GRANT role1 TO informix
GO
 
Go to file menu in ADS
Go to Options
Expand general option
Click on scripting
Select script drop on create
Click on ok button
 
Right click on 'role1'
Select script object to window as
Select CREATE
 
Statement separator is not generated in revoke statements
 

 

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

Issue #11699
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