SAP Sybase Forums - PowerBuilder - General Discussion - Get an error "Please connect as PowerBuilder Catalog Owner" × Sybase NNTP forums - End Of Life (EOL) The NNTP forums from Sybase - forums.sybase.com - are now closed. All new questions should be directed to the appropriate forum at the SAP Community Network (SCN). Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center. Forums Archive > PowerBuilder > General Discussion > "Get an error "Please connect as PowerBuilder Catalog Owner"" Get an error "Please connect as PowerBuilder Catalog Owner" 6 posts in General Discussion . Last posting was on 2004-02-13 16:11:26.0Z Hariharan Posted on 2004-02-12 22:24:48.0Z Sender: 6005.402bfc1b.1804289383@sybase.comFrom: HariharanNewsgroups: sybase.public.PowerBuilder.generalSubject: Get an error "Please connect as PowerBuilder Catalog Owner"X-Mailer: WebNews to Mail Gateway v1.1sMessage-ID: <402bfd30.6015.846930886@sybase.com>NNTP-Posting-Host: 10.22.241.41X-Original-NNTP-Posting-Host: 10.22.241.41Date: 12 Feb 2004 14:24:48 -0800X-Trace: forums-1-dub 1076624688 10.22.241.41 (12 Feb 2004 14:24:48 -0800)X-Original-Trace: 12 Feb 2004 14:24:48 -0800, 10.22.241.41Lines: 7Path: forums-1-dub!not-for-mailXref: forums-1-dub sybase.public.PowerBuilder.general:159571 Article PK: 611387 We use Oracle 9.2 and PB 9.0. When I connect to an Oracle instance from PB's Database Admin painter, I get the following error... "Please connect as the PowerBuilder Catalog Owner..." Please let me know do I resolve this. Bruce Armstrong [TeamSybase] Posted on 2004-02-12 22:51:54.0Z Message-ID: <402BFF4C.91E6E483@teamsybase.com>From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>Organization: TeamSybaseX-Mailer: Mozilla 4.73 [en]C-CCK-MCD Boeing Kit (Windows NT 5.0; U)X-Accept-Language: enMIME-Version: 1.0Newsgroups: sybase.public.PowerBuilder.generalSubject: Re: Get an error "Please connect as PowerBuilder Catalog Owner"References: <402bfd30.6015.846930886@sybase.com>Content-Type: text/plain; charset=us-asciiContent-Transfer-Encoding: 7bitX-Original-NNTP-Posting-Host: 141.102.124.34X-Original-Trace: 12 Feb 2004 15:02:55 -0800, 141.102.124.34Lines: 17X-Original-NNTP-Posting-Host: forums-2-dub.sybase.comX-Original-Trace: 12 Feb 2004 14:33:49 -0800, forums-2-dub.sybase.comNNTP-Posting-Host: forums-master.sybase.comX-Original-NNTP-Posting-Host: forums-master.sybase.comDate: 12 Feb 2004 14:51:54 -0800X-Trace: forums-1-dub 1076626314 10.22.108.75 (12 Feb 2004 14:51:54 -0800)X-Original-Trace: 12 Feb 2004 14:51:54 -0800, forums-master.sybase.comX-Authenticated-User: ngsysopPath: forums-1-dub!not-for-mailXref: forums-1-dub sybase.public.PowerBuilder.general:159573 Article PK: 611388 PB attempts to create the catalog tables when you first connect in the system tablespace. If you haven't logged in as someone who has rights to do that, do that now. If you aren't allowed to, change the "PowerBuilder Catalog Table Owner" property in the database connection profile and PB will create the tables in that users default tablespace. Hariharan wrote: > > We use Oracle 9.2 and PB 9.0. When I connect to an Oracle > instance from PB's Database Admin painter, I get the > following error... > > "Please connect as the PowerBuilder Catalog Owner..." > > Please let me know do I resolve this. Hariharan Posted on 2004-02-12 22:55:54.0Z Sender: 605c.402c03d0.1804289383@sybase.comFrom: HariharanNewsgroups: sybase.public.PowerBuilder.generalSubject: Re: Get an error "Please connect as PowerBuilder Catalog Owner"X-Mailer: WebNews to Mail Gateway v1.1sMessage-ID: <402c047a.6066.846930886@sybase.com>References: <402bfd30.6015.846930886@sybase.com><402BFF4C.91E6E483@teamsybase.com>NNTP-Posting-Host: 10.22.241.41X-Original-NNTP-Posting-Host: 10.22.241.41Date: 12 Feb 2004 14:55:54 -0800X-Trace: forums-1-dub 1076626554 10.22.241.41 (12 Feb 2004 14:55:54 -0800)X-Original-Trace: 12 Feb 2004 14:55:54 -0800, 10.22.241.41Lines: 37Path: forums-1-dub!not-for-mailXref: forums-1-dub sybase.public.PowerBuilder.general:159574 Article PK: 611392 Hi Bruce, Thanks for your help. I am able to connect with this instance using SQLPlusW.exe from my machine. It's only with PB9 that I get this error. Am I missing something in my connection profile? Below is the profile... // Profile duo015s.ntrs.com SQLCA.DBMS = "O90 Oracle9i (9.0.1)" SQLCA.LogPass = <*******> SQLCA.ServerName = "duo015s.ntrs.com" SQLCA.LogId = "naspcust" SQLCA.AutoCommit = False SQLCA.DBParm = "" > PB attempts to create the catalog tables when you first > connect in the system tablespace. If you haven't logged > in as someone who has rights to do that, do that now. > > If you aren't allowed to, change the "PowerBuilder Catalog > Table Owner" property in the database connection profile > and PB will create the tables in that users default > tablespace. > > Hariharan wrote: > > > > We use Oracle 9.2 and PB 9.0. When I connect to an > > Oracle instance from PB's Database Admin painter, I get > > the following error... > > > > "Please connect as the PowerBuilder Catalog Owner..." > > > > Please let me know do I resolve this. Bruce Armstrong [TeamSybase] Posted on 2004-02-12 23:50:45.0Z Message-ID: <402C0D16.A9DC3F6A@teamsybase.com>From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>Organization: TeamSybaseX-Mailer: Mozilla 4.73 [en]C-CCK-MCD Boeing Kit (Windows NT 5.0; U)X-Accept-Language: enMIME-Version: 1.0Newsgroups: sybase.public.PowerBuilder.generalSubject: Re: Get an error "Please connect as PowerBuilder Catalog Owner"References: <402bfd30.6015.846930886@sybase.com><402BFF4C.91E6E483@teamsybase.com> <402c047a.6066.846930886@sybase.com>Content-Type: text/plain; charset=us-asciiContent-Transfer-Encoding: 7bitX-Original-NNTP-Posting-Host: 141.102.124.34X-Original-Trace: 12 Feb 2004 16:01:45 -0800, 141.102.124.34Lines: 44X-Original-NNTP-Posting-Host: forums-2-dub.sybase.comX-Original-Trace: 12 Feb 2004 15:32:39 -0800, forums-2-dub.sybase.comNNTP-Posting-Host: forums-master.sybase.comX-Original-NNTP-Posting-Host: forums-master.sybase.comDate: 12 Feb 2004 15:50:45 -0800X-Trace: forums-1-dub 1076629845 10.22.108.75 (12 Feb 2004 15:50:45 -0800)X-Original-Trace: 12 Feb 2004 15:50:45 -0800, forums-master.sybase.comX-Authenticated-User: ngsysopPath: forums-1-dub!not-for-mailXref: forums-1-dub sybase.public.PowerBuilder.general:159576 Article PK: 611389 SQLPlusW doesn't use PowerBuilder's Catalog Tables. You might want to refer to this: Creating PowerBuilder Catalog Tables in a Specified Oracle Tablespace http://www.sybase.com/detail?id=44537 Hariharan wrote: > > Hi Bruce, > > Thanks for your help. > > I am able to connect with this instance using SQLPlusW.exe > from my machine. It's only with PB9 that I get this error. > Am I missing something in my connection profile? Below is > the profile... > > // Profile duo015s.ntrs.com > SQLCA.DBMS = "O90 Oracle9i (9.0.1)" > SQLCA.LogPass = <*******> > SQLCA.ServerName = "duo015s.ntrs.com" > SQLCA.LogId = "naspcust" > SQLCA.AutoCommit = False > SQLCA.DBParm = "" > > > PB attempts to create the catalog tables when you first > > connect in the system tablespace. If you haven't logged > > in as someone who has rights to do that, do that now. > > > > If you aren't allowed to, change the "PowerBuilder Catalog > > Table Owner" property in the database connection profile > > and PB will create the tables in that users default > > tablespace. > > > > Hariharan wrote: > > > > > > We use Oracle 9.2 and PB 9.0. When I connect to an > > > Oracle instance from PB's Database Admin painter, I get > > > the following error... > > > > > > "Please connect as the PowerBuilder Catalog Owner..." > > > > > > Please let me know do I resolve this. WS Posted on 2004-02-13 13:51:31.0Z Reply-To: "WS" <wizardofnet-at-yahoo.com>From: "WS" <wizardofnet-at-yahoo.com>Newsgroups: sybase.public.PowerBuilder.generalReferences: <402bfd30.6015.846930886@sybase.com><402BFF4C.91E6E483@teamsybase.com> <402c047a.6066.846930886@sybase.com>Subject: Re: Get an error "Please connect as PowerBuilder Catalog Owner"Lines: 45X-Priority: 3X-MSMail-Priority: NormalX-Newsreader: Microsoft Outlook Express 6.00.2800.1106X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106X-Original-NNTP-Posting-Host: sha5.sha.state.md.usMessage-ID: <402cd8f5$1@forums-2-dub>X-Original-Trace: 13 Feb 2004 06:02:29 -0800, sha5.sha.state.md.usX-Original-NNTP-Posting-Host: forums-2-dub.sybase.comX-Original-Trace: 13 Feb 2004 05:33:18 -0800, forums-2-dub.sybase.comNNTP-Posting-Host: forums-master.sybase.comX-Original-NNTP-Posting-Host: forums-master.sybase.comDate: 13 Feb 2004 05:51:31 -0800X-Trace: forums-1-dub 1076680291 10.22.108.75 (13 Feb 2004 05:51:31 -0800)X-Original-Trace: 13 Feb 2004 05:51:31 -0800, forums-master.sybase.comX-Authenticated-User: ngsysopPath: forums-1-dub!not-for-mailXref: forums-1-dub sybase.public.PowerBuilder.general:159603 Article PK: 611419 ask your dba to have "create table" rights for "naspcust" user and logon to oracle thru pb dbprofile. this would do the needed things for you. once these tables are created, dba could revoke this permission for this user. <Hariharan> wrote in message news:402c047a.6066.846930886@sybase.com... > Hi Bruce, > > Thanks for your help. > > I am able to connect with this instance using SQLPlusW.exe > from my machine. It's only with PB9 that I get this error. > Am I missing something in my connection profile? Below is > the profile... > > // Profile duo015s.ntrs.com > SQLCA.DBMS = "O90 Oracle9i (9.0.1)" > SQLCA.LogPass = <*******> > SQLCA.ServerName = "duo015s.ntrs.com" > SQLCA.LogId = "naspcust" > SQLCA.AutoCommit = False > SQLCA.DBParm = "" > > > > > PB attempts to create the catalog tables when you first > > connect in the system tablespace. If you haven't logged > > in as someone who has rights to do that, do that now. > > > > If you aren't allowed to, change the "PowerBuilder Catalog > > Table Owner" property in the database connection profile > > and PB will create the tables in that users default > > tablespace. > > > > Hariharan wrote: > > > > > > We use Oracle 9.2 and PB 9.0. When I connect to an > > > Oracle instance from PB's Database Admin painter, I get > > > the following error... > > > > > > "Please connect as the PowerBuilder Catalog Owner..." > > > > > > Please let me know do I resolve this. Ken Balakrishnan Posted on 2004-02-13 16:11:26.0Z From: "Ken Balakrishnan" <kNOeSPAMn@cps92.com>Newsgroups: sybase.public.PowerBuilder.generalReferences: <402bfd30.6015.846930886@sybase.com>Subject: Re: Get an error "Please connect as PowerBuilder Catalog Owner"Lines: 15X-Priority: 3X-MSMail-Priority: NormalX-Newsreader: Microsoft Outlook Express 6.00.2800.1158X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165X-Original-NNTP-Posting-Host: 204.60.85.209Message-ID: <402cf9c5@forums-2-dub>X-Original-Trace: 13 Feb 2004 08:22:29 -0800, 204.60.85.209X-Original-NNTP-Posting-Host: forums-2-dub.sybase.comX-Original-Trace: 13 Feb 2004 07:53:16 -0800, forums-2-dub.sybase.comNNTP-Posting-Host: forums-master.sybase.comX-Original-NNTP-Posting-Host: forums-master.sybase.comDate: 13 Feb 2004 08:11:26 -0800X-Trace: forums-1-dub 1076688686 10.22.108.75 (13 Feb 2004 08:11:26 -0800)X-Original-Trace: 13 Feb 2004 08:11:26 -0800, forums-master.sybase.comX-Authenticated-User: ngsysopPath: forums-1-dub!not-for-mailXref: forums-1-dub sybase.public.PowerBuilder.general:159620 Article PK: 611434 Go to the Database Painter, select Design->Options in the menu, and uncheck the "Use Extended Attributes" box on the first tabpage. Ken <Hariharan> wrote in message news:402bfd30.6015.846930886@sybase.com... > We use Oracle 9.2 and PB 9.0. When I connect to an Oracle > instance from PB's Database Admin painter, I get the > following error... > > "Please connect as the PowerBuilder Catalog Owner..." > > Please let me know do I resolve this. 漏 Copyright Sat Mar 01 23:37:39 UTC 2014, SAP Inc. - Forums Archive v 2.2