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.

your password will expire in x days

6 posts in General Discussion Last posting was on 2012-05-10 05:15:19.0Z
Van Posted on 2012-05-08 06:00:21.0Z
Reply-To: "Van" <Van@hotmail.com>
From: "Van" <Van@hotmail.com>
Newsgroups: sybase.public.ase.general
Subject: your password will expire in x days
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6090
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fa8b675@forums-1-dub>
Date: 7 May 2012 23:00:21 -0700
X-Trace: forums-1-dub 1336456821 10.22.241.152 (7 May 2012 23:00:21 -0700)
X-Original-Trace: 7 May 2012 23:00:21 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31092
Article PK: 73982

Sybase ASE , which SQL statement can give me this validating message ?

Any Ideas
Regards, Van


Van Posted on 2012-05-08 06:58:40.0Z
Reply-To: "Van" <Van@hotmail.com>
From: "Van" <Van@hotmail.com>
Newsgroups: sybase.public.ase.general
References: <4fa8b675@forums-1-dub>
Subject: Re: your password will expire in x days
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6090
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fa8c420@forums-1-dub>
Date: 7 May 2012 23:58:40 -0700
X-Trace: forums-1-dub 1336460320 10.22.241.152 (7 May 2012 23:58:40 -0700)
X-Original-Trace: 7 May 2012 23:58:40 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31093
Article PK: 73983

Hi There ,

Well , I tried using PB executable which reads an INI setting as below and
has NO EFFECT.
[COMPASS]
DBMS=SYC Adaptive Server Enterprise
Database=COMDB
UserID=
DBPass=
LogID=
LogPass=
DbParm=StaticBind=0,DelimitIdentifier='No',CursorUpdate=1,PWDialog=1,PWExpDialog=1
ServerName=CompassDEV

Regards

"Van" <Van@hotmail.com> wrote in message news:4fa8b675@forums-1-dub...
> Sybase ASE , which SQL statement can give me this validating message ?
>
> Any Ideas
> Regards, Van
>
>


Cory Sane [TeamSybase] Posted on 2012-05-08 09:30:19.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4fa8b675@forums-1-dub>
In-Reply-To: <4fa8b675@forums-1-dub>
Subject: Re: your password will expire in x days
Lines: 20
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fa8e7ab@forums-1-dub>
Date: 8 May 2012 02:30:19 -0700
X-Trace: forums-1-dub 1336469419 10.22.241.152 (8 May 2012 02:30:19 -0700)
X-Original-Trace: 8 May 2012 02:30:19 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31094
Article PK: 73984

Van,

The password expiration is set as a server wide CFG or per login.
The value can be seen in "sp_displaylogin myloginhere"
The per login option keeps the values stored in master..sysattributes
(Double Check these values)
where attribute=0 and object=(suid of the login) and type="PS"
and object_int = expiration

--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"Van" <Van@hotmail.com> wrote in message news:4fa8b675@forums-1-dub...
> Sybase ASE , which SQL statement can give me this validating message ?
>
> Any Ideas
> Regards, Van
>
>


Van Posted on 2012-05-09 04:08:33.0Z
Reply-To: "Van" <Van@hotmail.com>
From: "Van" <Van@hotmail.com>
Newsgroups: sybase.public.ase.general
References: <4fa8b675@forums-1-dub> <4fa8e7ab@forums-1-dub>
Subject: Re: your password will expire in x days
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6090
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fa9edc1@forums-1-dub>
Date: 8 May 2012 21:08:33 -0700
X-Trace: forums-1-dub 1336536513 10.22.241.152 (8 May 2012 21:08:33 -0700)
X-Original-Trace: 8 May 2012 21:08:33 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31096
Article PK: 73988

But how we get what is the date when the password was set so that we can
add "values ie.. Y days" to get ...

"Your password will expire in x days "
Regards , Van

"Cory Sane [TeamSybase]" <cory!=sane> wrote in message
news:4fa8e7ab@forums-1-dub...
> Van,
>
> The password expiration is set as a server wide CFG or per login.
> The value can be seen in "sp_displaylogin myloginhere"
> The per login option keeps the values stored in master..sysattributes
> (Double Check these values)
> where attribute=0 and object=(suid of the login) and type="PS"
> and object_int = expiration
>
> --
> Cory Sane
> [TeamSybase]
> Certified Sybase Associate DBA for ASE 15.0
> "Van" <Van@hotmail.com> wrote in message news:4fa8b675@forums-1-dub...
>> Sybase ASE , which SQL statement can give me this validating message ?
>>
>> Any Ideas
>> Regards, Van
>>


Luc Van der Veurst Posted on 2012-05-09 12:05:16.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.ase.general
References: <4fa8b675@forums-1-dub> <4fa8e7ab@forums-1-dub> <4fa9edc1@forums-1-dub>
Subject: Re: your password will expire in x days
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646: Format=Flowed; Response
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4faa5d7c@forums-1-dub>
Date: 9 May 2012 05:05:16 -0700
X-Trace: forums-1-dub 1336565116 10.22.241.152 (9 May 2012 05:05:16 -0700)
X-Original-Trace: 9 May 2012 05:05:16 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31099
Article PK: 73987

You can find the date when the password was last changed in
table master..syslogins (pwdate).

A user specific password expiration value is stored in master..sysattributes
(object = suid, objecttype = 'PS').

"Van" <Van@hotmail.com> wrote in message news:4fa9edc1@forums-1-dub...
> But how we get what is the date when the password was set so that we can
> add "values ie.. Y days" to get ...
>
> "Your password will expire in x days "
> Regards , Van
>
> "Cory Sane [TeamSybase]" <cory!=sane> wrote in message
> news:4fa8e7ab@forums-1-dub...
>> Van,
>>
>> The password expiration is set as a server wide CFG or per login.
>> The value can be seen in "sp_displaylogin myloginhere"
>> The per login option keeps the values stored in master..sysattributes
>> (Double Check these values)
>> where attribute=0 and object=(suid of the login) and type="PS"
>> and object_int = expiration
>>
>> --
>> Cory Sane
>> [TeamSybase]
>> Certified Sybase Associate DBA for ASE 15.0
>> "Van" <Van@hotmail.com> wrote in message news:4fa8b675@forums-1-dub...
>>> Sybase ASE , which SQL statement can give me this validating message ?
>>>
>>> Any Ideas
>>> Regards, Van
>>>
>


Van Posted on 2012-05-10 05:15:19.0Z
Reply-To: "Van" <Van@hotmail.com>
From: "Van" <Van@hotmail.com>
Newsgroups: sybase.public.ase.general
References: <4fa8b675@forums-1-dub> <4fa8e7ab@forums-1-dub> <4fa9edc1@forums-1-dub> <4faa5d7c@forums-1-dub>
Subject: Re: your password will expire in x days
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6090
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fab4ee7@forums-1-dub>
Date: 9 May 2012 22:15:19 -0700
X-Trace: forums-1-dub 1336626919 10.22.241.152 (9 May 2012 22:15:19 -0700)
X-Original-Trace: 9 May 2012 22:15:19 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31100
Article PK: 73990

Luc ,
Thank you , thats works with some calculation on getdate()

Thanks , regards
Van

"Luc Van der Veurst" <dba_azvub@hotmail.com> wrote in message
news:4faa5d7c@forums-1-dub...
>
> You can find the date when the password was last changed in
> table master..syslogins (pwdate).
>
> A user specific password expiration value is stored in
> master..sysattributes
> (object = suid, objecttype = 'PS').
>
>
> "Van" <Van@hotmail.com> wrote in message news:4fa9edc1@forums-1-dub...
>> But how we get what is the date when the password was set so that we can
>> add "values ie.. Y days" to get ...
>>
>> "Your password will expire in x days "
>> Regards , Van
>>
>> "Cory Sane [TeamSybase]" <cory!=sane> wrote in message
>> news:4fa8e7ab@forums-1-dub...
>>> Van,
>>>
>>> The password expiration is set as a server wide CFG or per login.
>>> The value can be seen in "sp_displaylogin myloginhere"
>>> The per login option keeps the values stored in master..sysattributes
>>> (Double Check these values)
>>> where attribute=0 and object=(suid of the login) and type="PS"
>>> and object_int = expiration
>>>
>>> --
>>> Cory Sane
>>> [TeamSybase]
>>> Certified Sybase Associate DBA for ASE 15.0
>>> "Van" <Van@hotmail.com> wrote in message news:4fa8b675@forums-1-dub...
>>>> Sybase ASE , which SQL statement can give me this validating message ?
>>>>
>>>> Any Ideas
>>>> Regards, Van
>>>>
>>
>
>