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.

Sybase 11.9.2 and adding/deleting new users

2 posts in Windows NT Last posting was on 2000-02-22 22:43:01.0Z
Brendan Bartlett Posted on 2000-02-22 21:23:07.0Z
Message-ID: <38B2FE3A.F336B3F8@yahoo.com>
Date: Tue, 22 Feb 2000 16:23:07 -0500
From: Brendan Bartlett <BrenBart@yahoo.com>
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Sybase 11.9.2 and adding/deleting new users
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 7
NNTP-Posting-Host: ip-226.207-89-157-0.unused.net-link.net 207.89.157.226
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2520
Article PK: 1089976

Is it possible to delegat the right to create/delete logins to a user
other than dbo?

Regards,

Brendan T.L. Bartlett
Manager, Technical Support Services
Unitrac Technologies, Inc.
(616)344-2141 x145
support@unitrac.com


Jason Froebe Posted on 2000-02-22 22:43:01.0Z
Message-ID: <38B310F5.6DB0F004@sybase.com>
Date: Tue, 22 Feb 2000 16:43:01 -0600
From: Jason Froebe <jfroebe@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Brendan Bartlett <BrenBart@yahoo.com>
Subject: Re: Sybase 11.9.2 and adding/deleting new users
References: <38B2FE3A.F336B3F8@yahoo.com>
Content-Type: multipart/mixed; boundary="------------3328E02587A9FE8306E6E85C"
Newsgroups: sybase.public.sqlserver.nt
Lines: 30
NNTP-Posting-Host: jfroebe-desktop.sybase.com 157.133.46.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2518
Article PK: 1089971


Brendan Bartlett wrote:

> Is it possible to delegat the right to create/delete logins to a user
> other than dbo?
>
> Regards,
>
> Brendan T.L. Bartlett
> Manager, Technical Support Services
> Unitrac Technologies, Inc.
> (616)344-2141 x145
> support@unitrac.com

Hi Brendan,

the ability to create a login requires the sa_role or sso_role roles.

I believe you mean a 'user' (adding a user to a database), then the
database owner or a user with sa_role or sso_role roles.

Jason


Download VCard jfroebe.vcf