
If you were logged in you would be able to see more operations.
|
|
|
QA Status: |
Done successfully
|
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));
|
Description
|
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));
|
Show » |
|