Logging in to your database for the first time
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 interfaceWhen 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.