解决方案 »
- 错误listener does not currently know of service requested in connect descriptor
- 有关oracle instantclient 创建odbc的问题
- Oracle中select语句
- rman备份恢复有关OEM问题!!
- 请教oracle job queue问题
- 查询表时遇到的问题???
- ?装完Oracle之后,登陆不了
- 怎样写代码自动重新连接服务器?
- 又来提问了,还是关于SQL的问题,高分相送!!!!!!!!!!
- Oracle入门求教
- windows server 2008+oracle 11g
- Java如何访问Oracle包里的变量
create user [username] identified by [password];
用户授权:
grant connect,resource to [username];
其他的按需要弄吧
另外,1楼的resource角色很危险!其含quota unlimited tablespace:
revoke unlimited tablespace from username;
alter user username quota unlimited on tablespace_name;
建立用户
授予权限使用plsqldeveloper搞就可以了,本身用的人不是很多,完全胜任.
先创建一个表空间,再创建用户abc,要给用户指定表空间,最后赋予该用户的权限。
CREATE TABLESPACE "abc_TAB"
LOGGING
DATAFILE 'E:\abc_TAB.ora' SIZE 100M
AUTOEXTEND
ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;CREATE USER abc PROFILE DEFAULT
IDENTIFIED BY abc DEFAULT TABLESPACE abc_TAB
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED
ON abc_TAB
QUOTA UNLIMITED
ON abc_TAB
ACCOUNT UNLOCK;grant connect to abc with admin option;
grant resource to abc with admin option;
grant create table to abc;
grant create procedure to abc;
grant create public synonym to abc;
grant create view to abc;
grant drop public synonym to abc;
grant grant any privilege to abc;
grant select any table to abc with admin option;
grant unlimited tablespace to abc with admin option;
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE
默认表空间是system表空间,,你可以指定users表空间。