Thursday, November 26, 2009

Oracle creating/removing new user

create user scott1 identified by tiger;
grant create session to scott1;
grant create table to scott1;
grant unlimited tablespace to scott1;

Drop user scott1 casecade;

Copying a table from another user's account :
create table booking as select * from scott.booking;

No comments:

Blog Archive