建用户和schema

[root@gaudi ~]# su - oracle

[oracle@gaudi ~]$ sqlplus "/ as sysdba"

 

SQL*Plus: Release 9.2.0.4.0 - Production on  Dec 10 10:21:12 2008

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

 

SQL> create user lkg identified by lkg;

 

User created.

 

SQL> grant connect,resource to lkg;

 

Grant succeeded.

 

SQL> alter user lkg default tablespace gau01d;

 

User altered.

 

 

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> grant CREATE MATERIALIZED VIEW to dev;

Grant succeeded.

 

SQL> create user devr identified by devr
  2  /

User created.

SQL> conn dev/dev
Connected.
SQL> grant select any table to devr;
grant select any table to devr
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> CREATE SYNONYM g103t for dev.g103t;

Synonym created.

SQL> select count(*) from g103t;

  COUNT(*)
----------
       468

SQL>