PDA

View Full Version : Create User



hithere
30-01-2004, 15:33
Toi dung nhung lenh sau:
- create user ngocdvt indentified by 123;
- grant create session, create table, create sequence, create view, create procedure to ngocdvt;
Cac lenh tren deu bao succeeded.
khi su dung user ngocdvt de logon thi Xuat hien thong bao loi
Error applying Automatic Debug Information mode: alter session privilege required
Van vao duoc CSDL, nhung khong create table duoc.
create table test(ID NUMBER, NAME VARCHAR2(20));
-thong bao loi khi create table:
create table test(ID NUMBER, NAME VARCHAR2(20))
ORA-01950: no privileges on tablespace 'SYSTEM'

Co ai biet chi giup voi.

pepsi_blue
31-01-2004, 14:50
Ban thu tao lai 1 user khac theo cach cua minh thu xem:
create user test identified by t123;
grant connect,resource to test;
alter user test
default tablespace users
temporary tablespace temp;
sau do ban connect vo user test va thu tao table
Chuc ban thanh cong!

past_beggar
20-03-2004, 07:46
grant dba to x là xong, đỡ phải đau đầu