Subject Re: [firebird-support] How to prevent SYSDBA to connect to database
Author Pablo Sánchez
Hi, that could be nice, but i get in isql :

SQL> create ROLE SYSDBA ;
Statement failed, SQLCODE = -607

unsuccessful metadata update
-user name SYSDBA could not be used for SQL role
SQL>

It could be nice, at least to keep some lurkers out of the job.

Best regards.
Pablo Sánchez.



>slavomirad schrieb:
>
>
>
>>Hi all.
>>
>>I have problem to prevent SYSDBA to connect to my database.
>>Is it possible? By writing some trigger which should be fired
>>when anybody connect to database?
>>
>>
>
>You can create a role SYSDBA, this should prevent the user SYSDBA from
>connecting.
>
>You cannot write any trigger for connecting to the database since
>connecting is not bound to a certain table.
>
>Luc.
>
>
>
>
>
>
>