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

Resolved RESOLVED: Database Script Question

  1. Issue
0
Votes
Undo
  1. Olan Knight
    Olan Knight
  2. PowerBuilder
  3. Monday, 19 June 2017 17:54 PM UTC

PBv12.1, build 7055

Oracle 12C

 

I have a new table that the DBAs created for testing.

I can logon as the Catalog Owner = "CHADBA".

I am unable to logon as any other user; the error is:

 

     "Please connect as the PowerBuilder Catalog Owner. This is

      necessary for the initial connection to Oracle to GRANT privileges

      on the repository".

 

What do I need to do in order to clean this up?

 

It sounds like a script needs to be run, but WHAT script? Developers are prohibited from DBA-level control upon pain of death here, so I've not had to do this before!  :O

 

 

Thanks,

 

Olan

  1. Database
  2. Script
  3. PowerBuilder
Are we really only two weeks away from PowerBuilde...
PDF Component for PowerBuilder
Accepted Answer
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Tuesday, 20 June 2017 19:34 PM UTC
  2. PowerBuilder
  3. # Permalink

From: "'Mikhailovsky, George' George.Mikhailovsky@calibresys.com [PowerObject]"
To: "PowerObject@yahoogroups.com"
Sent: Monday, June 19, 2017 3:26 PM
Subject: RE: [PowerObject] Re: Database Script Question

 

Olan,

I hope I got you now.

If database SBTRN12C already has proper privileges, execute

SELECT owner, table_name, grantee

FROM table_privileges

WHERE table_name LIKE 'pbcat%';

 

against it and then grant the same privileges to grantee that used by PB application using GRANT statement for each of pbcat… table in SBTRN12D database.

 

Best regards,

George

Comment
There are no comments made yet.
Responses (4)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Tuesday, 20 June 2017 19:35 PM UTC
  2. PowerBuilder
  3. # 1

Thank you to EVERYONE who responded - I appreciate it greatly!

I sent George's answer to the DBA - and it worked!

 

Thank You All,

Olan

Comment
There are no comments made yet.
Mike S
Mike S Accepted Answer Pending Moderation
  1. Tuesday, 20 June 2017 13:53 PM UTC
  2. PowerBuilder
  3. # 2

in the database profile setup screen, the system tab has PowerBuilder Catalog Table Owner - the default for oracle is SYSTEM.

Either change this  (which means you would need to change all the PB developers), or log in as system within the PB IDE (or have a dba do this).   PB will create the tables it wants, and after that change your login back to the one you are really working in.

Comment
There are no comments made yet.
Chris Pollach
Chris Pollach Accepted Answer Pending Moderation
  1. Monday, 19 June 2017 18:41 PM UTC
  2. PowerBuilder
  3. # 3

Hi Olan;

  All you need to do is to create the PBCATxxx tables under a DBA account. Your DBA can easily do that for you by running the DB scripts for those tables as provided for in your standard PB installation. The DML scripts are for Sybase DBMS's but, you can easily tweak them for Oracle's DML syntax. The other route is to let your DBA login to the Oracle DB via your PB IDE once to get the tables created.

HTH

Regards .. .Chris

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.