ORACLE学习笔记-新建用户及建表篇_oracle_

 create user SA identified by 2013; 

 /*授权connect,resource给用户sa*/ grant connect,resource to sa; 

 /*查询所有的用户*/ select * from all_users; 

 /*将表STU查询权限授予SA*/ GRANT SELECT ON STU TO SA /*将表STU添加权限授予SA*/ GRANT INSERT ON STU TO SA /*将表STU更新权限授予SA*/ GRANT UPDATE ON STU TO SA /*将表STU删除权限授予SA*/ GRANT DELETE ON STU TO SA 

 /*建表指定表空间*/ create table KC(KC_NO varchar2(10) not null,KC_NAME varchar2(50) not null) tablespace TEST; create table STU(STU_ID varchar2(10) not null,STU_NAME varchar2(50) not null,STU_AGE number(2) not null,STU_SET number(2) not null, KC_NO varchar2(10) not null) tablespace TEST; 

 /*创建约束，设置主键*/ ALTER TABLE STU ADD PRIMARY KEY(STU_ID) ALTER TABLE KC ADD PRIMARY KEY(KC_NO) /*查看表空间的表*/ Select table_name, tablespace_name from dba_tables where tablespace_name='TEST' 

 /*查询所有的表*/ select table_name,tablespace_name,temporary from user_tables