metadata update

25 views
Skip to first unread message

med didaoui

unread,
Jul 25, 2021, 4:30:18 AM7/25/21
to firebird-support
Hello please I migrate from firebird version 2.5 at 3.0.7 I created a user with privilege RDB$ADMIN I created an "ADM" Role
 SQL> grant alter database to role ADM;
 SQL> grant alter ANY table to ADM; 
 SQL> commit; 
 SQL> grant alter ANY procedure to ADM; 
 SQL> grant alter ANY generator to ADM;
 after I assigned this role to the created user but I still have this error

This operation is not defined for system tables.
unsuccessful metadata update.
ALTER TABLE TRANSFERT failed.
no permission for ALTER access to TABLE TRANSFERT.

 Please enlighten me
firebird.png

Dimitry Sibiryakov

unread,
Jul 25, 2021, 5:06:38 AM7/25/21
to firebird...@googlegroups.com
25.07.2021 10:30, med didaoui wrote:
> I assigned this role to the created user

Did you login using this user AND role?

--
WBR, SD.
Reply all
Reply to author
Forward
0 new messages