Subject | Re: [firebird-support] How to prevent SYSDBA to connect to database |
---|---|
Author | Pablo Sánchez |
Post date | 2004-02-19T18:00:56Z |
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.
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.
>
>
>
>
>
>
>