创建一个新用户test并给密码test
itkaifang@SYS> CREATE USER test IDENTIFIED BY test; User created. itkaifang@SYS>
修改用户密码
itkaifang@SYS> ALTER USER test IDENTIFIED BY test; User altered. itkaifang@SYS>
删除用户
itkaifang@SYS> DROP USER test CASCADE; User dropped. itkaifang@SYS>
创建一个新表class
itkaifang@TEST> CREATE TABLE class(cid NUMBER,cname VARCHAR2(20) NOT NULL,cdate DATE); Table created. itkaifang@TEST>
为表class添加一个列
itkaifang@TEST> ALTER TABLE class ADD(cemail VARCHAR2(20)); Table altered. itkaifang@TEST> desc class Name Null? Type ----------------------------------------- -------- ---------------------------- CID NUMBER CNAME NOT NULL VARCHAR2(20) CDATE DATE CEMAIL VARCHAR2(20) itkaifang@TEST>
修改cemail列类型为NUMBER
itkaifang@TEST> ALTER TABLE class MODIFY(cemail NUMBER); Table altered. itkaifang@TEST> desc class Name Null? Type ----------------------------------------- -------- ---------------------------- CID NUMBER CNAME NOT NULL VARCHAR2(20) CDATE DATE CEMAIL NUMBER itkaifang@TEST>
删除class表中一个列
itkaifang@TEST> ALTER TABLE class DROP COLUMN cemail; Table altered. itkaifang@TEST> desc class Name Null? Type ----------------------------------------- -------- ---------------------------- CID NUMBER CNAME NOT NULL VARCHAR2(20) CDATE DATE itkaifang@TEST>
权限:
create session
create table
unlimited tablespace
connect
resource
dba
给新建用户权限
SQL> grant create session,create table,connect,resource to scott; Grant succeeded. SQL>