Tuesday, July 10, 2007

system checking


It is a checking system that it can create an user and give privilege to it

CONNECT SYSTEM/MANAGER;

DROP USER ARKA CASCADE;

CREATE USER ARKA

IDENTIFIED BY STG;

GRANT create session, alter session, create table,

create view,

create sequence, UNLIMITED TABLESPACE to ARKA with admin option;

CONNECT ARKA/STG;

CREATE TABLE AR(NAME VARCHAR2(30));

No comments: