• 成为门户专家
• 打印
• 我的下载 (0)

• 支持
• Knowledge Base
• Toad for DB2

[EMEA] Showing the GRANTs for a role (or extract DDL) DATA ACCESS right is shown as CREATETAB (4239051)

×

返回

反馈已提交

本文是否解决了您的问题？

  [ 选择评价 ]

• 标题

  [EMEA] Showing the GRANTs for a role (or extract DDL) DATA ACCESS right is shown as CREATETAB

• 说明

  Showing the GRANTs for a role (or extract DDL) DATA ACCESS right is shown as CREATETAB right. so the CREATAB right might be duplicated and the DATA ACCESS is missing.

   

  Use the following commands to replicate the issue:

  db2 "CREATE ROLE IFCDS_SH_ADM"

  db2 "GRANT EXPLAIN, BINDADD, CREATE_EXTERNAL_ROUTINE, SQLADM, CREATETAB, DATAACCESS ON DATABASE TO ROLE IFCDS_SH_ADM"

   

  The go to Explorer | Security | Roles and select the IFCDS_SH_ADM role

  Switch to Grants tab . DATAACCESS is replaced by CREATETAB.

• 解决办法

  WORKAROUND

  None

  STATUS

  Issue fixed in Toad for DB2 8.0

  The latest version of Toad for DB2 can be downloaded here

   

• 缺陷ID

  TDB-3963

反馈已提交

本文是否解决了您的问题？

  [ 选择评价 ]

Request a KB Article

×

请求未来知识库文章主题

请求未来知识库文章主题

Products

------ 请选择 ------ Active Administrator Active Roles Active Roles Sync Service ApexSQL Analyze ApexSQL Audit ApexSQL Backup ApexSQL BI Monitor ApexSQL Build ApexSQL Compare ApexSQL Compare and Sync Toolkit Bundle ApexSQL Compare and Sync Toolkit Subscription ApexSQL Complete ApexSQL Data Diff ApexSQL Data Diff for MySQL ApexSQL Database Power Tools for VS Code ApexSQL Decrypt ApexSQL Defrag ApexSQL Devops Plus Toolkit Bundle ApexSQL DevOps Plus Toolkit Subscription ApexSQL DevOps Toolkit ApexSQL Devops Toolkit Bundle ApexSQL DevOps Toolkit Subscription ApexSQL Diff ApexSQL Diff for MySQL ApexSQL Discover ApexSQL Doc ApexSQL Doc for MySQL ApexSQL Doc Subscription ApexSQL Enforce ApexSQL Fundamentals Toolkit Bundle ApexSQL Fundamentals Toolkit for MySQL ApexSQL Fundamentals Toolkit Subscription ApexSQL Generate ApexSQL Job ApexSQL Log ApexSQL Manage ApexSQL Mask ApexSQL Model ApexSQL Monitor ApexSQL Operations Plus Toolkit Bundle ApexSQL Operations Toolkit Bundle ApexSQL Plan ApexSQL Propagate ApexSQL Pump ApexSQL Recover ApexSQL Refactor ApexSQL Script ApexSQL Search ApexSQL Source Control ApexSQL Source Control Subscription ApexSQL Trigger ApexSQL Unit Test ApexSQL VM Monitor Archive Manager Archive Manager for Exchange Archive Manager for Files Archive Shuttle Benchmark Factory for Database Change Auditor Code Tester for Oracle Coexistence Manager for Notes Collaboration Services Content Matrix ControlPoint Defender Directory Sync Pro for Active Directory Disaster Recovery for Identity Enterprise Reporter erwin Data Intelligence Cloud erwin Data Intelligence Suite erwin Data Modeler erwin Data Transformation erwin Enterprise Architect Agile erwin ER360 On Cloud erwin Evolve erwin Mart On Cloud erwin Sequence Essentials for Office 365 Foglight Foglight Cloud Foglight Evolve Foglight for Databases GoPlex NC-Access GPOADmin Identity Manager Identity Manager Data Governance Edition Identity Manager On Demand Identity Manager On Demand - Starling Edition InTrust IT Security Search KACE as a Service KACE Asset Management Appliance KACE Cloud KACE Desktop Authority KACE Service Desk KACE Systems Deployment Appliance KACE Systems Management Appliance KACE Unified Endpoint Manager LiteSpeed for SQL Server Live-Reorg MessageStats Migration Manager for AD Migration Manager for Exchange Migrator for Notes to Exchange Migrator for Notes to SharePoint Migrator Pro for Active Directory Migrator Pro for Exchange Multsess NC-Access NC-NIM NC-Pass NC-Pass Radius NC-Syncom Command NC-Syncom Password NCI NetVault NetVault Plus NetVault SmartDisk Nova On Demand Audit On Demand Migration On Demand Recovery One Identity Safeguard for Privileged Passwords One Identity Safeguard for Privileged Sessions ONELOGIN PAM Essentials Password Manager Privilege Manager for Unix Privileged Access Suite for Unix PST Flight Deck QoreStor Quick Connect for Active Directory Quick Connect for AS400 Quick Connect for Base Systems Quick Connect for Cloud Services Quick Connect for RACF Quick Connect Management Shell Quick Connect Sync Engine Rapid Recovery Recovery Manager for AD Recovery Manager for AD Disaster Recovery Edition Recovery Manager for AD Forest Edition Recovery Manager for Exchange Recovery Manager for Exchange - Data Protection Edition RemoteScan CheckCapture RemoteScan Enterprise RemoteScan Enterprise User Edition RemoteScan for LAN RemoteScan Terminal Services-Citrix RemoteScan Universal RemoteScan Universal User Edition Safeguard Authentication Services Safeguard for Privileged Passwords On Demand Safeguard for Privileged Sessions On Demand Safeguard for Sudo Safeguard On Demand Safeguard Privilege Manager for Windows Safeguard Remote Access Secure Copy Security Explorer Security Guardian Sensitive Content Manager SharePlex SharePlex Manager Space Manager with LiveReorg Spotlight on DB2 Spotlight on Oracle Spotlight on RAC Spotlight on SAP ASE Spotlight on SQL Server Enterprise Spotlight on Unix SQL Navigator for Oracle SQL Optimizer for DB2 LUW SQL Optimizer for DB2 ZOS SQL Optimizer for Oracle SQL Optimizer for SAP ASE SQL Optimizer for SQL Server Starling Cloud Assistant Starling Connect Stat StoragePoint syslog-ng Premium Edition syslog-ng Store Box Toad Data Modeler Toad Data Point Toad Data Point Subscription Toad Data Studio Toad Data Studio Subscription Toad DevOps Toolkit Toad Edge Toad for DB2 Toad for DB2 Subscription Toad for Oracle Toad for Oracle on Mac Toad for Oracle on Mac Subscription Toad for Oracle Subscription Toad for SAP Solutions Toad for SQL Server Toad for SQL Server Subscription Toad Intelligence Central TPAM Unified Communications Analytics Unified Communications Diagnostics vRanger

Topic

------ 请选择 ------ Best Practices Policy and Procedures Configuration How To Installation Licensing Troubleshooting

Title

Description

Email Address

提交

Leave a Comment

Send Comment必须在上方选择1至5颗星进行评级，才能发送评论

Thank you for your feedback for Topic Request

Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.

确定

×

建议的内容

Updating results

产品：

Toad for DB2
7.2

主题：

Troubleshooting

文章历史记录：

创建时间： 4/7/2022
上次更新时间： 2/12/2025

Thank you for your feedback for Topic Request

Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.

确定

×

 欢迎访问支持

您可以在附属支持站点上查找适用于戴尔*产品*的在线支持帮助。单击“继续”，转至适用于*产品*的正确支持内容和帮助。

搜索所有文章

© 2025 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center