IT开放社区

oracle数据库用户和表创建、删除、更改

创建一个新用户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>


发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

网站分类
站点信息
  • 文章总数:119
  • 页面总数:2
  • 分类总数:3
  • 标签总数:12
  • 评论总数:2
  • 浏览总数:116129
友情链接

BlogPowerBy Z-BlogPHP 1.5 Zero ;Theme By 爱墙纸

Copyright © 2020-2030 ITkaifang.COM All Rights Reserved. 京ICP备13044647号.Email:dreamerqin@qq.com