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

Chat now with support

Zurück

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

[Bewertung auswählen]

Titel

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

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.
Lösung

WORKAROUND

None

STATUS

Issue fixed in Toad for DB2 8.0

The latest version of Toad for DB2 can be downloaded here
Fehler-ID

TDB-3963

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

[Bewertung auswählen]

Empfohlener Inhalt

Titel