oracle 用户、角色管理，授权！

--创建临时表空间
create temporary tablespace user_temp
tempfile 'E:\oracle\product\10.2.0\oradata\ds\user_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;


--创建表空间
create tablespace user_data
logging
datafile 'E:\oracle\product\10.2.0\oradata\ds\user_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;


--创建用户指定表空间
create user username identified by password
default tablespace user_data
temporary tablespace user_temp;


--指定连接数据库权限
grant create session to username;


--修改密码
alter user username identified by password1;


--删除用户
drop user username;


--系统权限
--create seesion,create sequence,create synonym,create table,droup table
--droup procedure,execute any procedure,create user,drop user,create view
grant create SESSION,create user,create table to steve;


--WITH ADMIN OPTION ,所授权的用户就可以讲特权在授予其他用户
grant execute any procedure to username with admin option;


--讲特权授予public ,可以授予所有用户
grant execute any procedure to public;


--检查授予系统特权
select * from user_sys_privs order by privilege;


--撤销权限
revoke create table from steve;


--对象特权
--select ,insert,update,delete,execute
grant select,insert,update on username.test to steve;


--授予更新name 权限
grant update(name) on USERNAME.TEST to username;


--查询用户
select * from dba_users;

查看当前用户的缺省表空间
select username,default_tablespace from user_users;

--UNLIMITED TABLESPACE权限
 alter user username quota unlimited on USER_DATA;
 
 --检查已授予的对象特权
 select * from user_tab_privs_made;
 
 --

 grant create synonym to steve;

 --创建sequence,tigger

create sequence user_sequence
minvalue 1
maxvalue 9999999999999999
start with 1
increment by 1
nocache;


create trigger user_trigger before insert on T_USERS
for each row
begin
  select user_sequence.nextval into :new.userid from dual;
end;

 

。。。。。。。。。。。。