Example 1: Reusing the Current Database Attach for Another User

    SQL> ATTACH 'FILENAME db$:personnel';
    SQL> SET SESSION AUTHORIZATION 'USER ''SMITH'' USING ''SECRET1''';
    SQL> SHOW PRIV ON DATABASE RDB$DBHANDLE
    Privileges on Alias RDB$DBHANDLE
        (IDENTIFIER =[RDB,SMITH],ACCESS=SELECT+INSERT+UPDATE+DELETE+SHOW+CREATE+
         ALTER+DROP+DBCTRL+OPERATOR+DBADM+REFERENCES+SECURITY+DISTRIBTRAN)
    SQL> SET SESSION AUTHORIZATION 'USER ''JAIN'' USING ''SECRET2''';
    SQL> SHOW PRIV ON DATABASE RDB$DBHANDLE
    Privileges on Alias RDB$DBHANDLE
        (IDENTIFIER =[RDB,JAIN],ACCESS=SELECT+INSERT+UPDATE+DELETE+SHOW+CREATE+
         ALTER+DROP+DBCTRL+OPERATOR+DBADM+REFERENCES+SECURITY+DISTRIBTRAN)