Subject Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)
Author Bryan Cole
On Tue, 2018-12-18 at 17:08 +0100, Dimitry Sibiryakov sd@... [firebird-support] wrote:
18.12.2018 16:55, 'Bryan  Cole' bryan.cole@... [firebird-support] wrote:
I'm using the default which I believe is SRP.

   Make sure by select from MON$ATTACHMENTS.

Confirmed:

[bryan@bryan RPMS]$ isql-fb -user sysdba -pass mydbapassword localhost:employee
Database: localhost:employee, User: SYSDBA
SQL> select r.MON$USER, r.MON$AUTH_METHOD from MON$ATTACHMENTS r;

MON$USER                        MON$AUTH_METHOD                                                                                                                                                                                                                                                 
=============================== =============================================================================== 
SYSDBA                          Srp                                                                                                                                                                                                                                                             
Cache Writer                    <null>                                                                                                                                                                                                                                                          
Garbage Collector               <null>                                                                                                                                                                                                                                                          

SQL> 


Bryan