src/test/oraoop/create_users.sql

-- Licensed to the Apache Software Foundation (ASF) under one or more
-- contributor license agreements.  See the NOTICE file distributed with
-- this work for additional information regarding copyright ownership.
-- The ASF licenses this file to You under the Apache License, Version 2.0
-- (the "License"); you may not use this file except in compliance with
-- the License.  You may obtain a copy of the License at
--
--     http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.

create user sqooptest identified by 12345 default tablespace users;
alter user sqooptest quota unlimited on users;
grant create session to sqooptest;
grant create procedure to sqooptest;
grant alter session to sqooptest;
grant select on v_$instance to sqooptest;
grant select on dba_tables to sqooptest;
grant select on dba_tab_columns to sqooptest;
grant select on dba_objects to sqooptest;
grant select on dba_extents to sqooptest;
grant select on dba_segments to sqooptest;
grant select on v_$database to sqooptest;
grant select on v_$parameter to sqooptest;
grant select on v_$session to sqooptest;
grant select on v_$sql to sqooptest;
grant create table to sqooptest;
grant select on dba_tab_partitions to sqooptest;
grant select on dba_tab_subpartitions to sqooptest;
grant select on dba_indexes to sqooptest;
grant select on dba_ind_columns to sqooptest;
grant select any table to sqooptest;
grant create any table to sqooptest;
grant insert any table to sqooptest;
grant alter any table to sqooptest;

create user sqooptest2 identified by ABCDEF default tablespace users;
alter user sqooptest2 quota unlimited on users;
grant create session to sqooptest2;
grant create procedure to sqooptest2;
grant alter session to sqooptest2;
grant select on v_$instance to sqooptest2;
grant select on dba_tables to sqooptest2;
grant select on dba_tab_columns to sqooptest2;
grant select on dba_objects to sqooptest2;
grant select on dba_extents to sqooptest2;
grant select on dba_segments to sqooptest2;
grant select on v_$database to sqooptest2;
grant select on v_$parameter to sqooptest2;
grant select on v_$session to sqooptest2;
grant select on v_$sql to sqooptest2;
grant create table to sqooptest2;
grant select on dba_tab_partitions to sqooptest2;
grant select on dba_tab_subpartitions to sqooptest2;
grant select on dba_indexes to sqooptest2;
grant select on dba_ind_columns to sqooptest2;
grant select any table to sqooptest2;
grant create any table to sqooptest2;
grant insert any table to sqooptest2;
grant alter any table to sqooptest2;