Login Policy Password Expiration

[JimDiaz]

SQL Anywhere Version 12.0.1.3994

I’m interested in using the dbo.sa_post_login_procedure in a client application using an ODBC connection. What process would I use to select the message_text and message_action? Of course I could select * from dbo.sa_post_login_procedure after a connection but that wouldn’t work if the procedure was modified with the SET OPTION PUBLIC.post_login_procedure command. I’m interested in this being portable across databases. If the answer is I have to first SELECT CONNECTION_PROPERTY ( XYZ ), I think that's to much work.

On another note I was reviewing the dbo.sa_post_login_procedure in this version and can’t see how it works with the clause where login_policy_name = 'default' since the default login_policy_name is ‘root’.

Finally, whats with this not being able to type in plain text

[JimDiaz]

by the way thanks in advance

[Former Member]

Okay ... You can enquire the database option for that using the function db_property( 'post_login_procedure' ) and form the string 'call ' or 'select * from ' to pass to execute immediate.

The following works well enough in my QnD test in dbisql:

execute immediate with result set on string( 'select * from ', connection_property( 'post_login_procedure' ), '()' );

execute immediate with result set on string( 'call ', connection_property( 'post_login_procedure' ), '()' );

HTH

[JimDiaz]

Nick, thanks that will work.

Jim