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.

password policy

4 posts in General Discussion Last posting was on 2010-08-17 22:59:57.0Z
Rajasehkar Reddy Posted on 2010-08-17 06:17:55.0Z
Sender: 168c.4c6a2767.1804289383@sybase.com
From: Rajasehkar Reddy
Newsgroups: sybase.public.ase.general
Subject: password policy
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c6a2993.16bf.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Aug 2010 23:17:55 -0700
X-Trace: forums-1-dub 1282025875 10.22.241.41 (16 Aug 2010 23:17:55 -0700)
X-Original-Trace: 16 Aug 2010 23:17:55 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29466
Article PK: 78697

Hi,

Do we have any option that shouldn't doesn't to change
the password from last(previous) 10 passwords in Sybase ??
If yes, From What is version of ASE is it available ?

Thanks,
Rajasekhar Reddy


Rajasekhar Reddy Posted on 2010-08-17 06:56:46.0Z
Sender: 1750.4c6a2eae.1804289383@sybase.com
From: Rajasekhar Reddy
Newsgroups: sybase.public.ase.general
Subject: Re: password policy
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c6a32ad.17bd.1681692777@sybase.com>
References: <4c6a2993.16bf.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Aug 2010 23:56:46 -0700
X-Trace: forums-1-dub 1282028206 10.22.241.41 (16 Aug 2010 23:56:46 -0700)
X-Original-Trace: 16 Aug 2010 23:56:46 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29469
Article PK: 78700

Hi,

Do we have any option that doesn't allow us to change
the password from last(previous) 10 passwords in Sybase ??
If yes, From what version of ASE is it available ?

Thanks,
Raj.


Rob V [ Sybase ] Posted on 2010-08-17 10:49:15.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: password policy
References: <4c6a2993.16bf.1681692777@sybase.com> <4c6a32ad.17bd.1681692777@sybase.com>
In-Reply-To: <4c6a32ad.17bd.1681692777@sybase.com>
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: <4c6a692b$1@forums-1-dub>
Date: 17 Aug 2010 03:49:15 -0700
X-Trace: forums-1-dub 1282042155 10.22.241.152 (17 Aug 2010 03:49:15 -0700)
X-Original-Trace: 17 Aug 2010 03:49:15 -0700, vip152.sybase.com
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29470
Article PK: 78701


On 17-Aug-10 08:56, Rajasekhar Reddy wrote:
> Hi,
>
> Do we have any option that doesn't allow us to change
> the password from last(previous) 10 passwords in Sybase ??
> If yes, From what version of ASE is it available ?
>
> Thanks,
> Raj.

In ASE 12.5.4 or 15.0.2 (or later versions, in both cases), you can
create a stored proc sp_extrapwdchecks which performs customs processing
for password changes. You can implement your own history list checks for
example.
When the proc exists, this proc is automatically called when a login
password is set or changed. To refuse a password, you return a specific
error code.
See the docs for more details.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------


Rajasekhar Reddy Posted on 2010-08-17 22:59:57.0Z
Sender: 1750.4c6a2eae.1804289383@sybase.com
From: Rajasekhar Reddy
Newsgroups: sybase.public.ase.general
Subject: Re: password policy
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c6b146d.2aad.1681692777@sybase.com>
References: <4c6a692b$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Aug 2010 15:59:57 -0700
X-Trace: forums-1-dub 1282085997 10.22.241.41 (17 Aug 2010 15:59:57 -0700)
X-Original-Trace: 17 Aug 2010 15:59:57 -0700, 10.22.241.41
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29471
Article PK: 78702


> On 17-Aug-10 08:56, Rajasekhar Reddy wrote:
> > Hi,
> >
> > Do we have any option that doesn't allow us to
> > change the password from last(previous) 10 passwords in
> > Sybase ?? If yes, From what version of ASE is it
> available ? >
> > Thanks,
> > Raj.
>
> In ASE 12.5.4 or 15.0.2 (or later versions, in both cases)
> , you can create a stored proc sp_extrapwdchecks which
> performs customs processing for password changes. You can
> implement your own history list checks for example.
> When the proc exists, this proc is automatically called
> when a login password is set or changed. To refuse a
> password, you return a specific error code.
> See the docs for more details.
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Sybase Professional DBA for ASE
> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
> Reference Guide" "The Complete Sybase Replication Server
> Quick Reference Guide"
>
> mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
> http://www.sypron.nl
> Sypron B.V., Amersfoort, The Netherlands
> Chamber of Commerce 27138666
> ----------------------------------------------------------
> -------
>

Thanks Rob.