Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Changing user password


This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 4 - Last Post: Nov 10, 2017 12:32 PM Last Post By: Carlos Matos
Carlos Matos

Posts: 114
Registered: 6/25/01
Changing user password  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 10, 2017 6:35 AM
I'm trying to change the user password. On earlier versions of interbase a user other than SYSDBA user, was allowed to change his own password.
Now, on interbase 2017, I get "no permission for update/write access to table USERS by user ????

What's changed? What am I missing?
I'm using a TIBSecurityService component and than calling ModifyUser.

It raizes error at line 1691 of IBX.IBServices.pas:
IBDataBaseError(GDSLibrary);

Edited by: Carlos Matos on Nov 10, 2017 6:41 AM
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Changing user password [Edit]  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 10, 2017 10:46 AM   in response to: Carlos Matos in response to: Carlos Matos
Carlos Matos wrote:
I'm trying to change the user password. On earlier versions of interbase a user other than SYSDBA user, was allowed to change his own password.
Now, on interbase 2017, I get "no permission for update/write access to table USERS by user ????

What's changed? What am I missing?
I'm using a TIBSecurityService component and than calling ModifyUser.

It raizes error at line 1691 of IBX.IBServices.pas:
IBDataBaseError(GDSLibrary);

Edited by: Carlos Matos on Nov 10, 2017 6:41 AM

Connect to the admin.ib DB as sysdba and grant all to public on the users table.

Generally in the past the admin database only grants select to the public and
only sysdba has update rights. You might ave changed this in hte distant past
on the old admin.ib and forgotten you did that. I couldn't find an admin.ib
that shipped with the permissions to allows anyone but sysdba to update the
users table (albeit I did not look at more than 2 past ones).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Carlos Matos

Posts: 114
Registered: 6/25/01
Re: Changing user password [Edit]  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 10, 2017 12:15 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Jeff Overcash (TeamB) wrote:
Carlos Matos wrote:
I'm trying to change the user password. On earlier versions of interbase a user other than SYSDBA user, was allowed to change his own password.
Now, on interbase 2017, I get "no permission for update/write access to table USERS by user ????

What's changed? What am I missing?
I'm using a TIBSecurityService component and than calling ModifyUser.

It raizes error at line 1691 of IBX.IBServices.pas:
IBDataBaseError(GDSLibrary);

Edited by: Carlos Matos on Nov 10, 2017 6:41 AM

Connect to the admin.ib DB as sysdba and grant all to public on the users table.

Generally in the past the admin database only grants select to the public and
only sysdba has update rights. You might ave changed this in hte distant past
on the old admin.ib and forgotten you did that. I couldn't find an admin.ib
that shipped with the permissions to allows anyone but sysdba to update the
users table (albeit I did not look at more than 2 past ones).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

I don't understand or again I'm missing something.
I have a module that alows a certain user (non SYSDBA) to change is own password.
If I must connect to Admin.ib DB with SYSDBA to grant, how can this user know SYSDBA password to change is own password, if I must connect as SYSDBA?

Edited by: Carlos Matos on Nov 10, 2017 12:15 PM
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Changing user password [Edit] [Edit]  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 10, 2017 12:22 PM   in response to: Carlos Matos in response to: Carlos Matos
Carlos Matos wrote:
Jeff Overcash (TeamB) wrote:
Carlos Matos wrote:
I'm trying to change the user password. On earlier versions of interbase a user other than SYSDBA user, was allowed to change his own password.
Now, on interbase 2017, I get "no permission for update/write access to table USERS by user ????

What's changed? What am I missing?
I'm using a TIBSecurityService component and than calling ModifyUser.

It raizes error at line 1691 of IBX.IBServices.pas:
IBDataBaseError(GDSLibrary);

Edited by: Carlos Matos on Nov 10, 2017 6:41 AM
Connect to the admin.ib DB as sysdba and grant all to public on the users table.

Generally in the past the admin database only grants select to the public and
only sysdba has update rights. You might ave changed this in hte distant past
on the old admin.ib and forgotten you did that. I couldn't find an admin.ib
that shipped with the permissions to allows anyone but sysdba to update the
users table (albeit I did not look at more than 2 past ones).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

I don't understand or again I'm missing something.
I have a module that alows a certain user (non SYSDBA) to change is own password.
If I must connect to Admin.ib DB with SYSDBA to grant, how can this user know SYSDBA password to change is own password, if I must connect as SYSDBA?

Edited by: Carlos Matos on Nov 10, 2017 12:15 PM

You only have to connect to the admin.ib once as sysdba, grant full access
rights to the public on the USERS table (right now public only has select
rights) and then your users can update themselves since public has rights to.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Carlos Matos

Posts: 114
Registered: 6/25/01
Re: Changing user password [Edit] [Edit]  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 10, 2017 12:32 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Jeff Overcash (TeamB) wrote:
Carlos Matos wrote:
Jeff Overcash (TeamB) wrote:
Carlos Matos wrote:
I'm trying to change the user password. On earlier versions of interbase a user other than SYSDBA user, was allowed to change his own password.
Now, on interbase 2017, I get "no permission for update/write access to table USERS by user ????

What's changed? What am I missing?
I'm using a TIBSecurityService component and than calling ModifyUser.

It raizes error at line 1691 of IBX.IBServices.pas:
IBDataBaseError(GDSLibrary);

Edited by: Carlos Matos on Nov 10, 2017 6:41 AM
Connect to the admin.ib DB as sysdba and grant all to public on the users table.

Generally in the past the admin database only grants select to the public and
only sysdba has update rights. You might ave changed this in hte distant past
on the old admin.ib and forgotten you did that. I couldn't find an admin.ib
that shipped with the permissions to allows anyone but sysdba to update the
users table (albeit I did not look at more than 2 past ones).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

I don't understand or again I'm missing something.
I have a module that alows a certain user (non SYSDBA) to change is own password.
If I must connect to Admin.ib DB with SYSDBA to grant, how can this user know SYSDBA password to change is own password, if I must connect as SYSDBA?

Edited by: Carlos Matos on Nov 10, 2017 12:15 PM

You only have to connect to the admin.ib once as sysdba, grant full access
rights to the public on the USERS table (right now public only has select
rights) and then your users can update themselves since public has rights to.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Ok Jeff, understood. Thanks a lot.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02