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.

Bad Bad problem

5 posts in General Discussion (old) Last posting was on 2000-03-16 17:33:35.0Z
Bondi Blue Posted on 2000-03-10 19:59:22.0Z
Newsgroups: sybase.public.easerver
From: "Bondi Blue" <jwilliam@calpaksystems.com>
Subject: Bad Bad problem
Date: Fri, 10 Mar 2000 11:59:22 -0800
Lines: 18
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: mod-ca8-27.ix.netcom.com 207.92.167.155
Message-ID: <347_KSg6Qtsi$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26633
Article PK: 154414

Somehow in one of our databases, our DBA no longer has select permissions on
the system tables owned by SYS. This of course, means we can no longer
access anything. Can someone please tell me how to regain control of this
database? I have tried a rebuild once...that didn't help at all.

I would like to move the tables into a new database that I have select
privileges in, but every time I create a new database and start it as a
Network Server service, it starts up okay, but when I go to make a new
connection to it in Sybase Central, I type in the username and password, and
then browse to the database. It keeps coming back, "Request to Start/Stop
database denied". I'M NOT TRYING TO START OR STOP IT! IT'S ALREADY RUNNING
IN THE SYSTEM TRAY!

Help me please! This is so frustrating.

-Bondi Blue


Dean Jones [Team Sybase] Posted on 2000-03-10 23:02:00.0Z
Newsgroups: sybase.public.easerver
From: "Dean Jones [Team Sybase]" <dean_no_spam_@powerobjects.com>
Subject: Re: Bad Bad problem
Date: Fri, 10 Mar 2000 17:02:00 -0600
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: modem23.outtech.com 216.207.144.253
Message-ID: <347_A$4QeUui$GA.74@forums.sybase.com>
References: <347_KSg6Qtsi$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26611
Article PK: 157616

I would post in the database forum. What database?

--

Dean Jones, CPD Professional
Team Sybase
PowerTeam, Inc.

Seminar on April 26 and 27, Don't Miss it!
www.powerobjects.com/seminar

http://www.powerobjects.com

Bondi Blue <jwilliam@calpaksystems.com> wrote in message
news:KSg6Qtsi$GA.74@forums.sybase.com...
> Somehow in one of our databases, our DBA no longer has select permissions
on
> the system tables owned by SYS. This of course, means we can no longer
> access anything. Can someone please tell me how to regain control of this
> database? I have tried a rebuild once...that didn't help at all.
>
> I would like to move the tables into a new database that I have select
> privileges in, but every time I create a new database and start it as a
> Network Server service, it starts up okay, but when I go to make a new
> connection to it in Sybase Central, I type in the username and password,
and
> then browse to the database. It keeps coming back, "Request to Start/Stop
> database denied". I'M NOT TRYING TO START OR STOP IT! IT'S ALREADY
RUNNING
> IN THE SYSTEM TRAY!
>
> Help me please! This is so frustrating.
>
> -Bondi Blue
>
>


Bondi Blue Posted on 2000-03-11 00:43:18.0Z
Newsgroups: sybase.public.easerver
From: "Bondi Blue" <jwilliam@calpaksystems.com>
Subject: Re: Bad Bad problem
Date: Fri, 10 Mar 2000 16:43:18 -0800
Lines: 69
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: mod-ca9-19.ix.netcom.com 207.92.167.211
Message-ID: <347_RwPZ7Lvi$GA.111@forums.sybase.com>
References: <347_KSg6Qtsi$GA.74@forums.sybase.com> <347_A$4QeUui$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:1684
Article PK: 131006

I have an ASA 6.02 server running on Windows NT 4.0. I have a database that
I have started as a Network Server service. I communicate to that database
with jConnect, and yes, I do have the meta-information for the
database/jConnect.

However, something very terrible happened to the database. For some yet to
be explained reason, I can no longer see any tables in the database when
attempting to construct an SQL query with the Database Wizard. I go back
and look at the database tables on the server, and there they are, fully
populated with data.

So I decide to check the permissions available to user DBA.

Well it looks as if the only permissions allowed are full permissions on
tables that DBA created. However, DBA has no permissions on tables owned by
SYS.

I went ahead and authorized Select for DBA on all SYS tables. This didn't
change anything.

If you have any ideas in how to see the tables again in PowerJ's SQL
builder, please drop a line. I'd love to hear from you. :)

-Bondi Blue

Dean Jones [Team Sybase] wrote in message ...
>I would post in the database forum. What database?
>
>--
>
>Dean Jones, CPD Professional
>Team Sybase
>PowerTeam, Inc.
>
>Seminar on April 26 and 27, Don't Miss it!
>www.powerobjects.com/seminar
>
>http://www.powerobjects.com
>
>
>Bondi Blue <jwilliam@calpaksystems.com> wrote in message
>news:KSg6Qtsi$GA.74@forums.sybase.com...
>> Somehow in one of our databases, our DBA no longer has select permissions
>on
>> the system tables owned by SYS. This of course, means we can no longer
>> access anything. Can someone please tell me how to regain control of
this
>> database? I have tried a rebuild once...that didn't help at all.
>>
>> I would like to move the tables into a new database that I have select
>> privileges in, but every time I create a new database and start it as a
>> Network Server service, it starts up okay, but when I go to make a new
>> connection to it in Sybase Central, I type in the username and password,
>and
>> then browse to the database. It keeps coming back, "Request to
Start/Stop
>> database denied". I'M NOT TRYING TO START OR STOP IT! IT'S ALREADY
>RUNNING
>> IN THE SYSTEM TRAY!
>>
>> Help me please! This is so frustrating.
>>
>> -Bondi Blue
>>
>>
>
>


Timothy McConnell Posted on 2000-03-13 16:43:11.0Z
Newsgroups: sybase.public.easerver
From: "Timothy McConnell" <tmcconne@sybase.com>
Subject: Re: Bad Bad problem
Date: Mon, 13 Mar 2000 11:43:11 -0500
Lines: 81
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: tmcconne-pc.sybase.com 172.31.143.24
Message-ID: <347_yqBQKrQj$GA.285@forums.sybase.com>
References: <347_KSg6Qtsi$GA.74@forums.sybase.com> <347_A$4QeUui$GA.74@forums.sybase.com> <347_RwPZ7Lvi$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:1683
Article PK: 131004

Which version of PowerJ are you using?

Bondi Blue <jwilliam@calpaksystems.com> wrote in message
news:RwPZ7Lvi$GA.111@forums.sybase.com...
> I have an ASA 6.02 server running on Windows NT 4.0. I have a database
that
> I have started as a Network Server service. I communicate to that
database
> with jConnect, and yes, I do have the meta-information for the
> database/jConnect.
>
> However, something very terrible happened to the database. For some yet
to
> be explained reason, I can no longer see any tables in the database when
> attempting to construct an SQL query with the Database Wizard. I go back
> and look at the database tables on the server, and there they are, fully
> populated with data.
>
> So I decide to check the permissions available to user DBA.
>
> Well it looks as if the only permissions allowed are full permissions on
> tables that DBA created. However, DBA has no permissions on tables owned
by
> SYS.
>
> I went ahead and authorized Select for DBA on all SYS tables. This didn't
> change anything.
>
> If you have any ideas in how to see the tables again in PowerJ's SQL
> builder, please drop a line. I'd love to hear from you. :)
>
> -Bondi Blue
>
> Dean Jones [Team Sybase] wrote in message ...
> >I would post in the database forum. What database?
> >
> >--
> >
> >Dean Jones, CPD Professional
> >Team Sybase
> >PowerTeam, Inc.
> >
> >Seminar on April 26 and 27, Don't Miss it!
> >www.powerobjects.com/seminar
> >
> >http://www.powerobjects.com
> >
> >
> >Bondi Blue <jwilliam@calpaksystems.com> wrote in message
> >news:KSg6Qtsi$GA.74@forums.sybase.com...
> >> Somehow in one of our databases, our DBA no longer has select
permissions
> >on
> >> the system tables owned by SYS. This of course, means we can no longer
> >> access anything. Can someone please tell me how to regain control of
> this
> >> database? I have tried a rebuild once...that didn't help at all.
> >>
> >> I would like to move the tables into a new database that I have select
> >> privileges in, but every time I create a new database and start it as a
> >> Network Server service, it starts up okay, but when I go to make a new
> >> connection to it in Sybase Central, I type in the username and
password,
> >and
> >> then browse to the database. It keeps coming back, "Request to
> Start/Stop
> >> database denied". I'M NOT TRYING TO START OR STOP IT! IT'S ALREADY
> >RUNNING
> >> IN THE SYSTEM TRAY!
> >>
> >> Help me please! This is so frustrating.
> >>
> >> -Bondi Blue
> >>
> >>
> >
> >
>
>


Bondi Blue Posted on 2000-03-16 17:33:35.0Z
Newsgroups: sybase.public.easerver
From: "Bondi Blue" <jwilliam@calpaksystems.com>
Subject: Re: Bad Bad problem
Date: Thu, 16 Mar 2000 09:33:35 -0800
Lines: 91
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: mod-ca9-28.ix.netcom.com 207.92.167.220
Message-ID: <347_x222032j$GA.111@forums.sybase.com>
References: <347_KSg6Qtsi$GA.74@forums.sybase.com> <347_A$4QeUui$GA.74@forums.sybase.com> <347_RwPZ7Lvi$GA.111@forums.sybase.com> <347_yqBQKrQj$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:1682
Article PK: 131002

I'm using PowerJ 3.

-jw

Timothy McConnell wrote in message ...
>Which version of PowerJ are you using?
>
>Bondi Blue <jwilliam@calpaksystems.com> wrote in message
>news:RwPZ7Lvi$GA.111@forums.sybase.com...
>> I have an ASA 6.02 server running on Windows NT 4.0. I have a database
>that
>> I have started as a Network Server service. I communicate to that
>database
>> with jConnect, and yes, I do have the meta-information for the
>> database/jConnect.
>>
>> However, something very terrible happened to the database. For some yet
>to
>> be explained reason, I can no longer see any tables in the database when
>> attempting to construct an SQL query with the Database Wizard. I go back
>> and look at the database tables on the server, and there they are, fully
>> populated with data.
>>
>> So I decide to check the permissions available to user DBA.
>>
>> Well it looks as if the only permissions allowed are full permissions on
>> tables that DBA created. However, DBA has no permissions on tables owned
>by
>> SYS.
>>
>> I went ahead and authorized Select for DBA on all SYS tables. This
didn't
>> change anything.
>>
>> If you have any ideas in how to see the tables again in PowerJ's SQL
>> builder, please drop a line. I'd love to hear from you. :)
>>
>> -Bondi Blue
>>
>> Dean Jones [Team Sybase] wrote in message ...
>> >I would post in the database forum. What database?
>> >
>> >--
>> >
>> >Dean Jones, CPD Professional
>> >Team Sybase
>> >PowerTeam, Inc.
>> >
>> >Seminar on April 26 and 27, Don't Miss it!
>> >www.powerobjects.com/seminar
>> >
>> >http://www.powerobjects.com
>> >
>> >
>> >Bondi Blue <jwilliam@calpaksystems.com> wrote in message
>> >news:KSg6Qtsi$GA.74@forums.sybase.com...
>> >> Somehow in one of our databases, our DBA no longer has select
>permissions
>> >on
>> >> the system tables owned by SYS. This of course, means we can no
longer
>> >> access anything. Can someone please tell me how to regain control of
>> this
>> >> database? I have tried a rebuild once...that didn't help at all.
>> >>
>> >> I would like to move the tables into a new database that I have select
>> >> privileges in, but every time I create a new database and start it as
a
>> >> Network Server service, it starts up okay, but when I go to make a new
>> >> connection to it in Sybase Central, I type in the username and
>password,
>> >and
>> >> then browse to the database. It keeps coming back, "Request to
>> Start/Stop
>> >> database denied". I'M NOT TRYING TO START OR STOP IT! IT'S ALREADY
>> >RUNNING
>> >> IN THE SYSTEM TRAY!
>> >>
>> >> Help me please! This is so frustrating.
>> >>
>> >> -Bondi Blue
>> >>
>> >>
>> >
>> >
>>
>>
>
>