数据库笔记--------创建用户并授权

1.-----创建用户gkl
 

create user gkl identified by "123456";  

2-----授予登陆权限给用户gkl
 

grant create session to gkl;

3-------给用户gkl授予创建表的权限
 

grant create table to gkl;

4------ 赋予用户gkl查询表的权限
 

grant select on gkl.reward1 to gkl;

5------ 赋予用户gkl插入表的权限
 

grant insert on  gkl.reward1 to  gkl;

6-------赋予表空间(与便于有空间能插入数据)
 

grant  unlimited tablespace to gkl;

7 -----创建表
 

create table reward
(
rno char(20) primary key,
rname char (20) unique,
rage char (10),
rmoney char(50)
);

8------插入数据

insert into  reward values('191530144','管凯露','20','500');
insert into  reward values('191530150','张子杰','20','600')