Subject | Is this aproved ? |
---|---|
Author | Carlos H. Cantu |
Post date | 2000-12-04T17:13:17Z |
Hi people !
Since I didnt receive any answer from the IB gurus I had sent this
message, I would like to know what you guy think about this :
---------------------------------------------
I found a "solution" proposed by some people here in Brazil to "SOLVE" the
problem regarding security problems in IB with the SYSDBA user. Following
is a resume of what the guys proposed... I would like to hear from you gurus
if this is really a solution to the problem :
Steps :
1) GRANT ALL on RDB$RELATIONS to SYSDBA
2) REVOKE ALL on RDB$RELATIONS from SYSDBA
3) Remove the rights of SYSDBA to select, insert and update the
RDB$RELATIONS table, after that remove the SYSDBA rights (UPDATE and
INSERT) to the RDB$USER_PRIVILEGES table
4) Now you have a database that can be copied to any machine and no SYSDBA
will have any access to the database info/data.
[]s
Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com
Since I didnt receive any answer from the IB gurus I had sent this
message, I would like to know what you guy think about this :
---------------------------------------------
I found a "solution" proposed by some people here in Brazil to "SOLVE" the
problem regarding security problems in IB with the SYSDBA user. Following
is a resume of what the guys proposed... I would like to hear from you gurus
if this is really a solution to the problem :
Steps :
1) GRANT ALL on RDB$RELATIONS to SYSDBA
2) REVOKE ALL on RDB$RELATIONS from SYSDBA
3) Remove the rights of SYSDBA to select, insert and update the
RDB$RELATIONS table, after that remove the SYSDBA rights (UPDATE and
INSERT) to the RDB$USER_PRIVILEGES table
4) Now you have a database that can be copied to any machine and no SYSDBA
will have any access to the database info/data.
[]s
Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com