login using sys
i.e. / as sysdba
CREATE BIGFILE TABLESPACE tbs_perm_android_01
DATAFILE 'tbs_perm_android_01.dat'
SIZE 10M
AUTOEXTEND ON;
CREATE TEMPORARY TABLESPACE tbs_temp_android_01
TEMPFILE 'tbs_temp_android_01.dbf'
SIZE 5M
AUTOEXTEND ON;
CREATE USER android
IDENTIFIED BY android
DEFAULT TABLESPACE tbs_perm_android_01
TEMPORARY TABLESPACE tbs_temp_android_01
QUOTA 20M on tbs_perm_android_01;
GRANT create session TO android;
GRANT create table TO android;
GRANT create view TO android;
GRANT create any trigger TO android;
GRANT create any procedure TO android;
GRANT create sequence TO android;
GRANT create synonym TO android;
No comments:
Post a Comment