Subject Is this aproved ?
Author Carlos H. Cantu
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