On the
Oracle AI Database 26ai Enterprise Edition Release 23.26.1.2.0
using SQLcl 25.4.2.0
I can't use multiple schemas in one project.
To recreate :
conn -n sandbox_admin
CREATE USER userA IDENTIFIED BY "StrongPassword123!" DEFAULT TABLESPACE data;
CREATE USER userB IDENTIFIED BY "StrongPassword123!" DEFAULT TABLESPACE data;
GRANT DB_DEVELOPER_ROLE TO userA;
GRANT DB_DEVELOPER_ROLE TO userB;
ALTER USER userA QUOTA UNLIMITED ON data;
ALTER USER userB QUOTA UNLIMITED ON data;
GRANT ALL PRIVILEGES ON SCHEMA userB TO userA;
conn -n sandbox_userb
create table test_table (
id number primary key,
name varchar2(100)
);
conn -n sandbox_usera
select * from userb.test_table;
!mkdir test_project
cd test_project
project init -n test -schemas usera,userb
project export
Guessing the problem is the new grant all privileges on schema ? I tried granting SELECT_CATALOG_ROLE but that just makes the errors red instead of yellow
@rafal-grzegorczyk