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.

generate DDL for stored procs ASE 12.5.2

2 posts in General Discussion Last posting was on 2008-04-07 10:04:24.0Z
Gareth Davies Posted on 2008-04-04 11:19:15.0Z
From: Gareth Davies <gruff@sitemaker.cc>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: generate DDL for stored procs ASE 12.5.2
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f60eb3$1@forums-1-dub>
Date: 4 Apr 2008 03:19:15 -0800
X-Trace: forums-1-dub 1207307955 10.22.241.152 (4 Apr 2008 03:19:15 -0800)
X-Original-Trace: 4 Apr 2008 03:19:15 -0800, vip152.sybase.com
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:667
Article PK: 1088345

I seem to be losing permissions randomly when I edit stored procs (i.e.
they disappear from the permissions tab in the SP editor)

Also, when I generate DDL for a set of stored procs, I'm getting the error:
"An internal error occurred during: "Save script and/or Execution.".
Privilege without grantee!"

which I suspect is related. Is anyone else seeing this?

Gareth


Daniel Huang Posted on 2008-04-07 10:04:24.0Z
Reply-To: "Daniel Huang" <lihuang@sybase.com>
From: "Daniel Huang" <lihuang@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47f60eb3$1@forums-1-dub>
Subject: Re: generate DDL for stored procs ASE 12.5.2
Lines: 36
Organization: Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f9f1a8@forums-1-dub>
Date: 7 Apr 2008 03:04:24 -0700
X-Trace: forums-1-dub 1207562664 10.22.241.152 (7 Apr 2008 03:04:24 -0700)
X-Original-Trace: 7 Apr 2008 03:04:24 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:668
Article PK: 1088347

Hi, Gareth:

I tried changing permissions and generating DDL for a set of stored procs,
but could not reproduce the problem you described.

Could you provide the detailed repo. steps and scripts so I can look into
it?

--
Thanks and regards,

Daniel Huang

Sybase Software (China) Co., Ltd
Room 1202-1203, Building One,
Zhangjiang Semiconductor Industry Park
3000 Longdong Avenue
Pudong, Shanghai 201203
Email: lihuang@sybase.com

"Gareth Davies" <gruff@sitemaker.cc> wrote in message
news:47f60eb3$1@forums-1-dub...
>I seem to be losing permissions randomly when I edit stored procs (i.e.
>they disappear from the permissions tab in the SP editor)
>
> Also, when I generate DDL for a set of stored procs, I'm getting the
> error:
> "An internal error occurred during: "Save script and/or Execution.".
> Privilege without grantee!"
>
> which I suspect is related. Is anyone else seeing this?
>
> Gareth