--创建临时表空间
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;
--UNLIMITED TABLESPACE权限
alter user username quota unlimited on USER_DATA;
--检查已授予的对象特权
select * from user_tab_privs_made;
--
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;
。。。。。。。。。。。。