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.

Question about roles...

3 posts in Windows NT Last posting was on 2001-02-08 15:14:00.0Z
Office Automation Posted on 2001-02-02 20:07:08.0Z
From: "Office Automation" <office.automation@scotiabank.com.sv>
Subject: Question about roles...
Date: Fri, 2 Feb 2001 14:07:08 -0600
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <lu5kpXVjAHA.295@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 209.198.203.199
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1252
Article PK: 1088718

I created a role but when I tried to delete it the following appears:

01:53:22 PM DBMS SCOTIABANKSRV -- Maximum number of databases that may be
accessed by a transaction is 16. This number has been exceeded by this
query.

How can I delete a user-created role?

By the way, if I grant a user the sso-role (in a medium-size organization
could be fine to have more than one allowed to change passwords) there is
any way to restrict this user not to change sa password?.

TIA.


Bret Halford Posted on 2001-02-06 19:38:29.0Z
Message-ID: <3A8052B5.AFF2A80@sybase.com>
Date: Tue, 06 Feb 2001 12:38:29 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Question about roles...
References: <lu5kpXVjAHA.295@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 10
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1244
Article PK: 1088710


Office Automation wrote:

> I created a role but when I tried to delete it the following appears:
>
> 01:53:22 PM DBMS SCOTIABANKSRV -- Maximum number of databases that may be
> accessed by a transaction is 16. This number has been exceeded by this
> query.
>
> How can I delete a user-created role?
>

This is CR 142307. It is fixed in current ASE 12.0 rollups.

-bret


jmbarillas Posted on 2001-02-08 15:14:00.0Z
From: jmbarillas@scotiabank.com.sv
Subject: Re: Question about roles...
References: <lu5kpXVjAHA.295@forums.sybase.com> <3A8052B5.AFF2A80@sybase.com>
X-Newsreader: Lotus Notes Release 5.0 March 30, 1999
X-Priority: 3 (Normal)
X-MIMETrack: Serialize by Notes Client on JAIME MAURICIO BARILLAS/SV/ScotiaBank(Release 5.0 |March 30, 1999) at 08/02/2001 08:58:27 AM, Serialize complete at 08/02/2001 08:58:27 AM
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="=_alternative 00524177062569ED_="
Message-ID: <HyIzDHekAHA.258@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Thu, 08 Feb 2001 10:14:00 -0500
Lines: 15
NNTP-Posting-Host: 209.198.203.199
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1235
Article PK: 1088708


Thank you.
We are using 11.9.2.1 SWR 8741 on an NT 4.0 box, any advice on it?

Tia.