By default, PowerBuilder creates the extended attribute system tables the first time you connect to a database.
To ensure that PowerBuilder creates the extended attribute system tables with the proper access rights to make them available to all users, the first person to connect to the database with PowerBuilder must log in with the proper authority.
To ensure proper creation of the PowerBuilder extended
attribute system tables:
Make sure the first person to connect to the database with PowerBuilder has sufficient authority to create tables and grant permissions to PUBLIC.
This means that the first person to connect to the database should log in as the database owner, database administrator, system user, system administrator, or system owner, as specified by your DBMS.
Creating the extended attribute system tables when
using the DirectConnect interface
When you are using the DirectConnect interface, the PowerBuilder extended attribute
system tables are not created automatically
the first time you connect to a database. You must run the DB2SYSPB.SQL script
to create the system tables, as described in “Using the DB2SYSPB.SQL script”.
