Toad World® Forums

generated authorizations incomplete

In Toad ß 5.5.0.335 the Script generation for authorizations is incomplete. It seems, all authorizations from SYSIBM are ignored. In Toad 5.3.0.928 these authorizations are included within the generated script.

Toad Menu: Object Security , Subpoint Users, Mark a User, Select Script

  • Toad 5.3
    SET SCHAMA = “USER1”;
    GRANT …;
    GRANT …;

    SET SCHAMA = “DB2INST1”;
    GRANT …;
    GRANT …;

    SET SCHEMA = “SYSIBM”;
    GRANT …;
    GRANT …;

    SET CURRENT SCHEMA = “DB2INST1”;
  • Toad 5.5
    SET SCHAMA = “USER1”;
    GRANT …;
    GRANT …;

    SET SCHAMA = “DB2INST1”;
    GRANT …;
    GRANT …;

It was implemented so in 5.5 by design to prevent implicitly created grants to be scripted.

If you want to see implicitly created grants then you can 1) go to the “Grants” tab or 2) Open “Edit table privileges…” dialog

This is no good solutiion. You don’t get a complete overview of the permissions of an existing user. If you like to add a user with privileges like existing on, you have to go to each table, view, function, … and so on. In most cases you miss something.

Perhaps it is possible to add a tab for implicitly created grants or have a setting to see / generate them all.

You do not have to go to each tab to clone all object privileges (grants) for a given user.

You can easily clone a user's privileges by selecting the user and selecting create like as shown below.