oracle 知识点
select * from dual;create tablespace test_sapce datafile 'E:\YC59\space\AAAA' size 10M;
alter tablespace test_sapce add datafile 'E:\YC59\space\AAAA_1' size 10M;
drop tablespace test_sapce including contents and datafiles;
/*****************用户管理*************************/
/*
创建用户的语法:
create user 用户名 identified by 密码 default tablespace 表空间名称
*/
create user gerry identified by a123 default tablespace test_sapce;
create user zhangsan identified by a123 default tablespace test_sapce;
/*
给用户授权:grant 权限名称 to 用户名
*/
-- 给gerry用户授予登录的权限
grant create session to gerry;
-- 给gerry用户授予resource角色
grant resource to gerry;
-- 给gerry用户授予查询scott用户emp表的操作
grant select,update,delete,insert on scott.emp to gerry;
/*
创建角色
*/
create role pro_role;
drop role pro_role;
/*
给角色授权
*/
grant resource to pro_role;
grant create session to pro_role;
grant select on scott.emp to pro_role;
/*
把创建的角色赋予用户gerry,zhangsan
*/
grant pro_role to gerry;
grant pro_role to zhangsan;
/*
回收权限
revoke 权限名称/ 角色名称 from 用户
*/
revoke select on scott.emp from gerry;
revoke resource from gerry;
revoke create session from gerry;
revoke pro_role from gerry;
/*
修改用户的密码,锁定用户，解锁用户
*/
alter user gerry identified by gerry;
-- 锁定用户
alter user gerry account lock;
-- 解锁用户
alter user gerry account unlock;
/*
删除用户
*/
drop user zhangsan cascade;select * from dual;
create tablespace test_sapce datafile 'E:\YC59\space\AAAA' size 10M;
alter tablespace test_sapce add datafile 'E:\YC59\space\AAAA_1' size 10M;
drop tablespace test_sapce including contents and datafiles;
/*****************用户管理*************************/
/*
创建用户的语法:
create user 用户名 identified by 密码 default tablespace 表空间名称
*/
create user gerry identified by a123 default tablespace test_sapce;
create user zhangsan identified by a123 default tablespace test_sapce;
/*
给用户授权:grant 权限名称 to 用户名
*/
-- 给gerry用户授予登录的权限
grant create session to gerry;
-- 给gerry用户授予resource角色
grant resource to gerry;
-- 给gerry用户授予查询scott用户emp表的操作
grant select,update,delete,insert on scott.emp to gerry;
/*
创建角色
*/
create role pro_role;
drop role pro_role;
/*
给角色授权
*/
grant resource to pro_role;
grant create session to pro_role;
grant select on scott.emp to pro_role;
/*
把创建的角色赋予用户gerry,zhangsan
*/
grant pro_role to gerry;
grant pro_role to zhangsan;
/*
回收权限
revoke 权限名称/ 角色名称 from 用户
*/
revoke select on scott.emp from gerry;
revoke resource from gerry;
revoke create session from gerry;
revoke pro_role from gerry;
/*
修改用户的密码,锁定用户，解锁用户
*/
alter user gerry identified by gerry;
-- 锁定用户
alter user gerry account lock;
-- 解锁用户
alter user gerry account unlock;
/*
删除用户
*/
drop user zhangsan cascade;
页:
[1]