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

Resolved PowerBuilder Catalog Owner

  1. Advice
0
Votes
Undo
  1. Akhtar Abbas
    Akhtar Abbas
  2. InfoMaker
  3. Wednesday, 17 January 2024 14:22 PM UTC

"Please Connect as a PowerBuilder Catalog Owner. This is necessary for the initial connection to Oracle to GRANT privileges on the repository."
Kindly advise how to resolve this issue

Frozen Exe
ORA-00942: Table or view does not exist
Responses (2)
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Wednesday, 17 January 2024 14:35 PM UTC
  2. InfoMaker
  3. # 1

Powerbuilder need five tables (PBCATxxx) for its extendended attributes. You can specify the catalog table owner in the database profile settings on the "System" tab.

You need to connect once with this catalog table owner with PB so it can create this tables.

Comment
Akhtar Abbas
  1. Akhtar Abbas
  2. Wednesday, 17 January 2024 14:41 PM UTC
Kindly advise the steps.
  1. Helpful
Kevin Ridley
  1. Kevin Ridley
  2. Wednesday, 17 January 2024 15:09 PM UTC
As Rene mentioned above, please checkout this thread:

https://community.appeon.com/index.php/qna/q-a/error-please-connect-as-a-powerbuilder-catalog-owner



Chris had a response that should work for you.
  1. Helpful
There are no comments made yet.
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Wednesday, 17 January 2024 14:52 PM UTC
  2. InfoMaker
  3. # 2

Set username and password for the catalog table owner (specified at "System" tab) on the "Connection" tab and connect to the database.

For example: For an Oracle DB the catalog owner is SYSTEM. So simple use Login-ID SYSTEM and its password in the "Connection" settings to connect to the database. 

If you don't want to use the default catalog owner you can specify another one you have access to.

See also here for some tipps: https://community.appeon.com/index.php/qna/q-a/error-please-connect-as-a-powerbuilder-catalog-owner

Once the tables are created you can switch back to the connection settings you want to use.

 

Comment
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.