• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Error: Please Connect as a PowerBuilder Catalog Owner

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Error: Please Connect as a PowerBuilder Catalog Owner

  1. How-to
0
Votes
Undo
  1. Leonid Shchervinsky
    Leonid Shchervinsky
  2. PowerBuilder
  3. Wednesday, 10 June 2020 03:16 AM UTC

Hi:

I am getting the following error:

"Please Connect as a PowerBuilder Catalog Owner. This is necessary for the initial connection to Oracle to GRANT privileges on the repository."

How would I resolve this error?

Thanks

API for read version
pbm_tbnmoved event for toolbars
Responses (3)
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Friday, 12 June 2020 04:28 AM UTC
  2. PowerBuilder
  3. # 1

Hi Leonid,

if it is not an option to add the five tables in SYSTEM schema once with the help of your db admins you may try tp specify another schema for catalog tabes: Change your connection profile. On "System" tab is an option "Powerbuilder catalog table owner". Change it to a schema where you have permission to.

If this does not help you may also deactivate the use of this tables. But you can only change it in your IDE globally for all connections! (I would prefer to have such option in connection properties.) In the database painter you find under the menu Design->Options the Property "Use extended attributes". If you deactivate it Powerbuilde does not use the tables. But you will miss also some helpful functionality.

HTH,

René

Comment
There are no comments made yet.
Leonid Shchervinsky
Leonid Shchervinsky Accepted Answer Pending Moderation
  1. Wednesday, 10 June 2020 04:33 AM UTC
  2. PowerBuilder
  3. # 2

Hi:

I have typed my database id in the System>"PowerBuilder Catalog Table Owner" field, and now I am getting the following message:
"ORA-01031: insufficient privileges"

What is the best way to resolve the problem connecting to the database without changing current privileges on the database?

Thanks

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 10 June 2020 15:51 PM UTC
  2. PowerBuilder
  3. # 3

Hi Lenoid;

    I would suggest having your DBA use the PB IDE once and have them login to your new DB using their credentials and then open the DB Painter. All the IDE would like to do at that point (1st time into the new DB) is create the PBCATxxxx tables. For that to happen, the DB Painter needs a DB Login with DBA (DBO) authority to perform the  "Create Table" DDL.

    Once your DBA has performed the above and the PBCATxxx tables exist, you and the rest of the development team should never get that message again.

HTH

Regards ... Chris

Comment
Leonid Shchervinsky
  1. Leonid Shchervinsky
  2. Thursday, 11 June 2020 23:29 PM UTC
Thanks Chris:

I am not sure if the corporate DBAs will let us add anything to the database that is not business application related.

would you know where these tables get created, under which schema, how many tables, and what information do the store? can these tables be created with a script? If the team connects to the database from PowerBuilder with their own ids, how does the PowerBuilder IDE know to locate these tables?

Thanks

Leonid
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 12 June 2020 00:51 AM UTC
Hi Leonid;

There are 5 tables ... PBCATTBL. PBCATCOL, PBCATFMT, PBCATEDT, and PBCATVLD.

These tables are not connected to a specific schema and must reside in the same Table Space with your working tables. They retain the "system" as the owner.

Regards ... Chris

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.