Board index » delphi » Change password for users

Jimm

Delphi Developer
Sat, 29 Jan 2005 14:35:55 GMT

Change password for users

Is there any way of changing the password for a single user using a SQL-statement?

Regards
Jimmy

 
Martijn Tonie

Delphi Developer
Sat, 29 Jan 2005 15:52:37 GMT

Re:Change password for users


Using SQL - no.

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Quote
"Jimmy" <jnilsson81 .com> wrote in message news:3d58a8cb$1@dnews...

> Is there any way of changing the password for a single user using a
SQL-statement?

> Regards
> Jimmy

Jimm

Delphi Developer
Sat, 29 Jan 2005 16:05:03 GMT

Re:Change password for users


Is there any other way of doing it besides of opening the IBconsole?

Quote
"Martijn Tonies" <m.tonies@upscene_remove.com> wrote:
>Using SQL - no.

>--
>Martijn Tonies
>InterBase Workbench - the developer tool for InterBase and Firebird
>http://www.interbaseworkbench.com

>Upscene Productions
>http://www.upscene.com

>"This is an object-oriented system.
>If we change anything, the users object."

>"Jimmy" <jnilsson81 .com> wrote in message news:3d58a8cb$1@dnews...

>> Is there any way of changing the password for a single user using a
>SQL-statement?

>> Regards
>> Jimmy

Martijn Tonie

Delphi Developer
Sat, 29 Jan 2005 17:36:01 GMT

Re:Change password for users


Hi Jimmy,

If you're using IB 6 SuperServer architecture, you can use the Services API
to do it. Have a look at the Developers Guide.

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Quote

> Is there any other way of doing it besides of opening the IBconsole?

> "Martijn Tonies" <m.tonies@upscene_remove.com> wrote:
> >Using SQL - no.

> >--
> >Martijn Tonies
> >InterBase Workbench - the developer tool for InterBase and Firebird
> >http://www.interbaseworkbench.com

> >Upscene Productions
> >http://www.upscene.com

> >"This is an object-oriented system.
> >If we change anything, the users object."

> >"Jimmy" <jnilsson81 .com> wrote in message news:3d58a8cb$1@dnews...

> >> Is there any way of changing the password for a single user using a
> >SQL-statement?

> >> Regards
> >> Jimmy

Jimm

Delphi Developer
Sat, 29 Jan 2005 17:52:42 GMT

Re:Change password for users


I am using IB 6 Open Source and I'm having a website using asp with users in interbase. I Would like so that the users can change their password on their own from the website if it's possible?

/Jimmy

Quote
"Martijn Tonies" <m.tonies@upscene_remove.com> wrote:
>Hi Jimmy,

>If you're using IB 6 SuperServer architecture, you can use the Services API
>to do it. Have a look at the Developers Guide.

>--
>Martijn Tonies
>InterBase Workbench - the developer tool for InterBase and Firebird
>http://www.interbaseworkbench.com

>Upscene Productions
>http://www.upscene.com

>"This is an object-oriented system.
>If we change anything, the users object."

>> Is there any other way of doing it besides of opening the IBconsole?

>> "Martijn Tonies" <m.tonies@upscene_remove.com> wrote:
>> >Using SQL - no.

>> >--
>> >Martijn Tonies
>> >InterBase Workbench - the developer tool for InterBase and Firebird
>> >http://www.interbaseworkbench.com

>> >Upscene Productions
>> >http://www.upscene.com

>> >"This is an object-oriented system.
>> >If we change anything, the users object."

>> >"Jimmy" <jnilsson81 .com> wrote in message news:3d58a8cb$1@dnews...

>> >> Is there any way of changing the password for a single user using a
>> >SQL-statement?

>> >> Regards
>> >> Jimmy

Ivan Prenosi

Delphi Developer
Sat, 29 Jan 2005 18:14:49 GMT

Re:Change password for users


Quote
> Is there any other way of doing it besides of opening the IBconsole?

e.g.
- using new Services API
- using old API functions (isc_modify_user() ...)
- using GSEC utility
- by direct updating isc4.gdb database (if you insist on "using SQL statement" :)

--
Ivan
http://www.volny.cz/iprenosil/interbase

JAC2

Delphi Developer
Sat, 29 Jan 2005 17:50:03 GMT

Re:Change password for users


What version of IB are you using < 6?

JAC

Quote
"Jimmy" <jnilsso...@hotmail.com> wrote in message news:3d58a8cb$1@dnews...

> Is there any way of changing the password for a single user using a
SQL-statement?

> Regards
> Jimmy

Martijn Tonie

Delphi Developer
Sat, 29 Jan 2005 18:56:49 GMT

Re:Change password for users


Hi Jimmy,

For such an application, I wouldn't even use the user system inside
InterBase.

Why not create a single user that has access to the database and create your
own
table with user/password combinations? That way, it's much easier for you.

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Quote
> I am using IB 6 Open Source and I'm having a website using asp with users

in interbase. I Would like so that the users can change their password on
their own from the website if it's possible?
Quote

> /Jimmy

> "Martijn Tonies" <m.tonies@upscene_remove.com> wrote:
> >Hi Jimmy,

> >If you're using IB 6 SuperServer architecture, you can use the Services
API
> >to do it. Have a look at the Developers Guide.

> >--
> >Martijn Tonies
> >InterBase Workbench - the developer tool for InterBase and Firebird
> >http://www.interbaseworkbench.com

> >Upscene Productions
> >http://www.upscene.com

> >"This is an object-oriented system.
> >If we change anything, the users object."

> >> Is there any other way of doing it besides of opening the IBconsole?

> >> "Martijn Tonies" <m.tonies@upscene_remove.com> wrote:
> >> >Using SQL - no.

> >> >--
> >> >Martijn Tonies
> >> >InterBase Workbench - the developer tool for InterBase and Firebird
> >> >http://www.interbaseworkbench.com

> >> >Upscene Productions
> >> >http://www.upscene.com

> >> >"This is an object-oriented system.
> >> >If we change anything, the users object."

> >> >"Jimmy" <jnilsson81 .com> wrote in message news:3d58a8cb$1@dnews...

> >> >> Is there any way of changing the password for a single user using a
> >> >SQL-statement?

> >> >> Regards
> >> >> Jimmy

Jimm

Delphi Developer
Sat, 29 Jan 2005 18:58:47 GMT

Re:Change password for users


That was my opinion from the beginning also but I'm not the one calling the shots. So I don't really know how to solve it.
Jimmy

Quote
"Martijn Tonies" <m.tonies@upscene_remove.com> wrote:
>Hi Jimmy,

>For such an application, I wouldn't even use the user system inside
>InterBase.

>Why not create a single user that has access to the database and create your
>own
>table with user/password combinations? That way, it's much easier for you.

>--
>Martijn Tonies
>InterBase Workbench - the developer tool for InterBase and Firebird
>http://www.interbaseworkbench.com

>Upscene Productions
>http://www.upscene.com

>"This is an object-oriented system.
>If we change anything, the users object."

>> I am using IB 6 Open Source and I'm having a website using asp with users
>in interbase. I Would like so that the users can change their password on
>their own from the website if it's possible?

>> /Jimmy

>> "Martijn Tonies" <m.tonies@upscene_remove.com> wrote:
>> >Hi Jimmy,

>> >If you're using IB 6 SuperServer architecture, you can use the Services
>API
>> >to do it. Have a look at the Developers Guide.

>> >--
>> >Martijn Tonies
>> >InterBase Workbench - the developer tool for InterBase and Firebird
>> >http://www.interbaseworkbench.com

>> >Upscene Productions
>> >http://www.upscene.com

>> >"This is an object-oriented system.
>> >If we change anything, the users object."

>> >> Is there any other way of doing it besides of opening the IBconsole?

>> >> "Martijn Tonies" <m.tonies@upscene_remove.com> wrote:
>> >> >Using SQL - no.

>> >> >--
>> >> >Martijn Tonies
>> >> >InterBase Workbench - the developer tool for InterBase and Firebird
>> >> >http://www.interbaseworkbench.com

>> >> >Upscene Productions
>> >> >http://www.upscene.com

>> >> >"This is an object-oriented system.
>> >> >If we change anything, the users object."

>> >> >"Jimmy" <jnilsson81 .com> wrote in message news:3d58a8cb$1@dnews...

>> >> >> Is there any way of changing the password for a single user using a
>> >> >SQL-statement?

>> >> >> Regards
>> >> >> Jimmy

Jimm

Delphi Developer
Sat, 29 Jan 2005 19:38:19 GMT

Re:Change password for users


IB 6 Open Source, read my other responses

"Jason Chapman \(JAC2\)" <ja...@jac2.co.uk> wrote:

Quote
>What version of IB are you using < 6?

>JAC

>"Jimmy" <jnilsso...@hotmail.com> wrote in message news:3d58a8cb$1@dnews...

>> Is there any way of changing the password for a single user using a
>SQL-statement?

>> Regards
>> Jimmy

Paul

Delphi Developer
Sat, 29 Jan 2005 21:03:29 GMT

Re:Change password for users


Quote
"Ivan Prenosil" <preno...@ms.anet.cz> wrote:
> > Is there any other way of doing it besides of opening the IBconsole?
> - using new Services API
> - using old API functions (isc_modify_user() ...)
> - using GSEC utility
> - by direct updating isc4.gdb database (if you insist on "using SQL statement" :)

This seems to completely solve his problem - is it against good
practice?

Paul...

Quote
> Ivan

--

plinehan__AT__yahoo__DOT__com

Craig Stuntz [TeamB

Delphi Developer
Sun, 30 Jan 2005 01:35:40 GMT

Re:Change password for users


In article <3d590378.10421...@127.0.0.1>, p...@not.a.chance.ie says...
Quote
> > - using new Services API
> > - using old API functions (isc_modify_user() ...)
> > - using GSEC utility
> > - by direct updating isc4.gdb database (if you insist on "using SQL statement" :)

> This seems to completely solve his problem - is it against good
> practice?

        Which of the four options is "this?"  GSEC and the Services API
should be supported in future versions of IB; with the others you risk
that they might not work in the future.  All four work, though.  The old
API functions provide no way to get the list of current users, however.

        -Craig

--
 Craig Stuntz [TeamB] Vertex Systems Corp. Columbus, OH
     Delphi/InterBase Weblog: http://delphi.weblogs.com
     InterBase PLANalyzer (Free IB optimization tool):
          http://delphi.weblogs.com/IBPLANalyzer

Jimm

Delphi Developer
Sun, 30 Jan 2005 15:09:59 GMT

Re:Change password for users


I'm kind of new to Interbase but I'll read the reference and hopefully I'll solve it. Thanks for your help!
/Jimmy

Craig Stuntz [TeamB] <cstu...@nospamplease.vertexsoftware.com> wrote:

Quote
>In article <3d590378.10421...@127.0.0.1>, p...@not.a.chance.ie says...
>> > - using new Services API
>> > - using old API functions (isc_modify_user() ...)
>> > - using GSEC utility
>> > - by direct updating isc4.gdb database (if you insist on "using SQL statement" :)

>> This seems to completely solve his problem - is it against good
>> practice?

>    Which of the four options is "this?"  GSEC and the Services API
>should be supported in future versions of IB; with the others you risk
>that they might not work in the future.  All four work, though.  The old
>API functions provide no way to get the list of current users, however.

>    -Craig

>--
> Craig Stuntz [TeamB] Vertex Systems Corp. Columbus, OH
>     Delphi/InterBase Weblog: http://delphi.weblogs.com
>     InterBase PLANalyzer (Free IB optimization tool):
>          http://delphi.weblogs.com/IBPLANalyzer

Paul

Delphi Developer
Wed, 02 Feb 2005 01:46:41 GMT

Re:Change password for users


Craig Stuntz [TeamB] <cstu...@nospamplease.vertexsoftware.com> wrote:

Quote
> > > - using new Services API
> > > - using old API functions (isc_modify_user() ...)
> > > - using GSEC utility
> > > - by direct updating isc4.gdb database (if you insist on "using SQL statement" :)
> > This seems to completely solve his problem - is it against good
> > practice?
>    Which of the four options is "this?"  GSEC and the Services API
> should be supported in future versions of IB; with the others you risk
> that they might not work in the future.  All four work, though.  The old
> API functions provide no way to get the list of current users, however.

I meant the last of the options, but as I said, I was wondering about
whether this is considered good practice?

Paul...

Quote
>    -Craig

--

plinehan__AT__yahoo__DOT__com

Craig Stuntz [TeamB

Delphi Developer
Wed, 02 Feb 2005 02:44:53 GMT

Re:Change password for users


In article <3d5d3a7c.11038...@127.0.0.1>, p...@not.a.chance.ie says...
Quote
> I meant the last of the options, but as I said, I was wondering about
> whether this is considered good practice?

        It works fine today; it may not work in future versions -- or it
may require serious changes.  Two BorCons ago the IB team implied that
there would be changes in how user security works.  

        -Craig

--
 Craig Stuntz [TeamB] Vertex Systems Corp. Columbus, OH
     Delphi/InterBase Weblog: http://delphi.weblogs.com
     InterBase PLANalyzer (Free IB optimization tool):
          http://delphi.weblogs.com/IBPLANalyzer

Other Threads

1. How to change user password in IB Database 5.6 without SYSDBA password

2. Interbase Password and User add/change via Delphi?

3. How to change User's password

4. Changing User Password in Oracle 8

5. Change user IB password from application.

6. SQL links: Informix: change User/Password ?

7. Change User Password

8. Change User Password

9. How to change user passwords in app

10. Using SQL to change User's Password