Subject Re: FB 2.0: What is the SQL to allow users to change their password?
Author Martijn Tonies
>From: "ashikkerib"
><m.tonies@...> wrote:
>>
>> Via the Services API or "gsec".
>>
>> Not via SQL.
>>
>> Martijn Tonies
>
>Quoting from release notes: "The SYSDBA remains the keeper of the
>security database but users can now modify their own passwords by way
>of a view over the (new) underlying, protected RDB$USERS table."
>
>Seems to me there is a way to change it via view ... real-life example
>would help greatly.

Then try it. You cannot connect to the security database, it is prohibited.





Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com