create table allclimate
(
   phonenum varchar2(11) primary key,
   area varchar2(20)
)

//dba

create user crm identified by crm default tablespace glarebell temporary
tablespace temp;

ALTER USER CRM DEFAULT TABLESPACE GLAREBELL;

ALTER USER CRM QUOTA UNLIMITED ON GLAREBELL;

grant select on v_$session to crm;

grant select on v_$sessstat to crm;

grant select on v_$statname to crm;

GRANT CREATE TABLE TO CRM;

grant alter,delete,update,insert,select on glarebell.allclimate to crm;

select * from glarebell.allclimate;

insert into glarebell.allclimate values('13328234213','FZ')

UPDATE GLAREBELL.ALLCLIMATE SET area='xm'

CREATE TABLE TEMPDB
(ID VARCHAR2(10))

DROP TABLE TEMPDB;

grant dba to glarebell;

发表于 @ 2006年06月08日 11:14:00|评论(loading...)|编辑