You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The script should provide an error "no permission for REFERENCES access to TABLE T1" but passes OK.
create database sysdba;
create user user1 password 'pass';
create table t1 (id int not null primary key, name varchar(100));
grant create table to user1;
connect user1;
create table t2 (id int references t1(id));
SCL_references must be checked for DDL operation of index creation and we need to ignore TDBB_trusted_ddl flag in this case. More general solution is to remove TDBB_trusted_dll flag since its purpose to allow system table modification due DDL operations. It requires removing SCL_checks... from VIO_{store,erase,motify}. It's quite possible but not so trivial as at fist look.
Submitted by: @romansimakov
The script should provide an error "no permission for REFERENCES access to TABLE T1" but passes OK.
create database sysdba;
create user user1 password 'pass';
create table t1 (id int not null primary key, name varchar(100));
grant create table to user1;
connect user1;
create table t2 (id int references t1(id));
Commits: ec94304 56d03a6
The text was updated successfully, but these errors were encountered: