给某个用户授权

CREATE TABLESPACE bmjj
LOGGING
DATAFILE 'D:\oracle\product\10.2.0\ORADATA\ORCL\bmjj.DBF' 
SIZE 32M 
AUTOEXTEND ON 
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;


CREATE USER bmjj IDENTIFIED BY bmjj
DEFAULT TABLESPACE bmjj;

授DBA权限

grant dba to archive

GRANT 
　　CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
　　ALTER ANY TABLE, ALTER ANY PROCEDURE,
　　DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
　　SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
　　TO bmjj;

下面语句是授个别权限

grant select on user1.table to user2

把user1的table表的select 权限授予user2