| Subject | Problem with user access rights after restore |
|---|---|
| Author | tomkrej |
| Post date | 2009-08-14T14:00:24Z |
Hi, I have problems with access rights to some tables in our DB after restore.
We are using two users for accessing database - one power user - he is owner of almost all tables - second for web apps. - has very restricted access, but creates few tables for some statistics.
We need the access right for SELECT on these stat.tables for main user.
But sometimes after restore database forgot these rights.
In IBExepert in DDL sheet I can see that the user has select rights, but when I try to select table it raises an error.
I have to revoke the right and then grant it back to enable access to DB. The only new grant doesnt work.
These problems are detected on FB1.5, and now during conversion from 1.5 to 2.0 too.
For restore we are using our main user, not SYSDBA (SYSDBA has prohibited access using role SYSDBA)
Thank You, Tom
We are using two users for accessing database - one power user - he is owner of almost all tables - second for web apps. - has very restricted access, but creates few tables for some statistics.
We need the access right for SELECT on these stat.tables for main user.
But sometimes after restore database forgot these rights.
In IBExepert in DDL sheet I can see that the user has select rights, but when I try to select table it raises an error.
I have to revoke the right and then grant it back to enable access to DB. The only new grant doesnt work.
These problems are detected on FB1.5, and now during conversion from 1.5 to 2.0 too.
For restore we are using our main user, not SYSDBA (SYSDBA has prohibited access using role SYSDBA)
Thank You, Tom