subject:"\[Firebird\-devel\] INDEX ON SYSTEM RELATIONS"

Re: [Firebird-devel] INDEX ON SYSTEM RELATIONS

2017-03-29 Thread Alex Peshkoff

On 03/29/17 13:52, Roman Simakov wrote: > Hi! > > Now FB3 prohibits operations like > > SQL> create index RDB$USER_PRIV_REL_USER on > RDB$USER_PRIVILEGES(RDB$RELATION_NAME,RDB$USER); > Statement failed, SQLSTATE = 28000 > unsuccessful metadata update > -CREATE INDEX RDB$USER_PRIV_REL_USER failed >

[Firebird-devel] INDEX ON SYSTEM RELATIONS

2017-03-29 Thread Roman Simakov

Hi! Now FB3 prohibits operations like SQL> create index RDB$USER_PRIV_REL_USER on RDB$USER_PRIVILEGES(RDB$RELATION_NAME,RDB$USER); Statement failed, SQLSTATE = 28000 unsuccessful metadata update -CREATE INDEX RDB$USER_PRIV_REL_USER failed -no permission for ALTER access to TABLE RDB$USER_PRIVILEG