杨高峰行动并快乐着

ALTER USER scott ACCOUNT UNLOCK;
CREATE USER gavin IDENTIFIED BY gavin
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE TEMP;
GRANT connect, resource TO gavin;
REVOKE UNLIMITED TABLESPACE FROM gavin;
ALTER USER gavin QUOTA UNLIMITED ON users;
-- ALTER USER gavin QUOTA 100m ON users;