PBSYC2.SQL script – PB Docs 126

What it does

The PBSYC2.SQL script contains SQL code that drops and re-creates
one PowerBuilder stored procedure in the Adaptive Server sybsystemprocs database:
a replacement version of sp_pb126table.

The default version of sp_pb126table is
installed by the PBSYC.SQL script. PowerBuilder uses
the sp_pb126table procedure to build
a list of all tables in the database, including
those for which the current user has no permissions. This list displays
in the Select Tables dialog box in PowerBuilder.

For security reasons, you or your database administrator might
want to restrict the table list to display only those tables for
which a user has permissions. To do this, you can run the PBSYC2.SQL script after
you run PBSYC.SQL. PBSYC2.SQL replaces
the default version of sp_pb126table with
a new version that displays a restricted table list including only
tables and views:

• Owned by
  the current user

• For which the current user has SELECT authority

• For which the current user’s group has SELECT authority

• For which SELECT authority was
  granted to PUBLIC

When to run it

If you are accessing an Adaptive Server database using the
ASE or SYC DBMS identifier in PowerBuilder, you must
first run PBSYC.SQL once per database server to install
the required PowerBuilder stored procedures in the sybsystemprocs
database.

After you run PBSYC.SQL, you can optionally
run PBSYC2.SQL if you want to replace sp_pb126table with
a version that restricts the table list to those tables for which
the user has SELECT permission.

If you do not want to restrict the table list, there is no
need to run PBSYC2.SQL.

For instructions on running PBSYC2.SQL,
see “How to run the scripts”.

Stored procedure it creates

The PBSYC2.SQL script creates the following PowerBuilder stored
procedure in the Adaptive Server sybsystemprocs database: