sqlplus

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Aug 6 19:44:21 2007

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> @fubar
SQL> create user ray identified by ID10T default tablespace users temporary tablespace temp;

User created.

SQL> grant create session to ray;

Grant succeeded.

SQL> grant create table to ray;

Grant succeeded.

SQL> grant create ROLE  to ray;

Grant succeeded.

SQL> GRANT UNLIMITED TABLESPACE TO ray;

Grant succeeded.

SQL> create user MIG identified by FUBAR default tablespace users temporary tablespace temp;

User created.

SQL> grant create session to mig;

Grant succeeded.

SQL> connect ray/ID10T
Connected.
SQL> create table MTE_LOG (ID varchar2(8));

Table created.

SQL> insert into MTE_LOG VALUES ('TEST');

1 row created.

SQL> create role ray_select;

Role created.

SQL> grant select on RAY.MTE_LOG to RAY_SELECT;

Grant succeeded.

SQL> grant RAY_SELECT to MIG;

Grant succeeded.

SQL> connect MIG/FUBAR
Connected.
SQL> select * from RAY.MTE_LOG;

ID
--------
TEST

SQL>