ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';----创建表空间 这里的路径示现场情况而定
CREATE TABLESPACE MIS_DATA
DATAFILE 'd:\oracledata\TDMIS_DATA.ora' SIZE 5M
REUSE AUTOEXTEND
ON NEXT 1K
MAXSIZE UNLIMITED
DEFAULT STORAGE
( INITIAL 1K
NEXT 10K
MINEXTENTS 10
MAXEXTENTS UNLIMITED
PCTINCREASE 0 )
MINIMUM EXTENT 1K; ---创建用户 8.1.x临时文件为TEMP;8.0.x临时文件为TEMPORARY
CREATE USER TDMIS
IDENTIFIED BY vic&mis
DEFAULT TABLESPACE MIS_DATA
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON MIS_DATA; ----归档日志(联机备份用)要赋予dba权限,没有归档日志可不设
GRANT CONNECT,RESOURCE,EXP_FULL_DATABASE,IMP_FULL_DATABASE TO TDMIS; ALTER USER TDMIS DEFAULT ROLE ALL;
GRANT SELECT ON SYS.DBA_DATA_FILES TO TDMIS;
GRANT CREATE TABLE TO TDMIS;
GRANT CREATE TABLESPACE TO TDMIS;
GRANT UNLIMITED TABLESPACE TO TDMIS;
GRANT CREATE VIEW TO TDMIS;
GRANT CREATE TABLE,EXECUTE ANY PROCEDURE,MANAGE TABLESPACE,ALTER SYSTEM,ALTER DATABASE TO TDMIS; GRANT CREATE PROCEDURE TO TDMIS;
GRANT EXECUTE ON SYS.DBMS_SQL TO TDMIS;
GRANT EXECUTE ON SYS.DBMS_JOB TO TDMIS; GRANT EXECUTE ON SYS.DBMS_LOB TO TDMIS;
上述脚本创建了一个用户,在用TDMIS/vic&mis 登录的时候登录不上,请问是不是因为密码中包含&造成的 请问如何解决
CREATE TABLESPACE MIS_DATA
DATAFILE 'd:\oracledata\TDMIS_DATA.ora' SIZE 5M
REUSE AUTOEXTEND
ON NEXT 1K
MAXSIZE UNLIMITED
DEFAULT STORAGE
( INITIAL 1K
NEXT 10K
MINEXTENTS 10
MAXEXTENTS UNLIMITED
PCTINCREASE 0 )
MINIMUM EXTENT 1K; ---创建用户 8.1.x临时文件为TEMP;8.0.x临时文件为TEMPORARY
CREATE USER TDMIS
IDENTIFIED BY vic&mis
DEFAULT TABLESPACE MIS_DATA
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON MIS_DATA; ----归档日志(联机备份用)要赋予dba权限,没有归档日志可不设
GRANT CONNECT,RESOURCE,EXP_FULL_DATABASE,IMP_FULL_DATABASE TO TDMIS; ALTER USER TDMIS DEFAULT ROLE ALL;
GRANT SELECT ON SYS.DBA_DATA_FILES TO TDMIS;
GRANT CREATE TABLE TO TDMIS;
GRANT CREATE TABLESPACE TO TDMIS;
GRANT UNLIMITED TABLESPACE TO TDMIS;
GRANT CREATE VIEW TO TDMIS;
GRANT CREATE TABLE,EXECUTE ANY PROCEDURE,MANAGE TABLESPACE,ALTER SYSTEM,ALTER DATABASE TO TDMIS; GRANT CREATE PROCEDURE TO TDMIS;
GRANT EXECUTE ON SYS.DBMS_SQL TO TDMIS;
GRANT EXECUTE ON SYS.DBMS_JOB TO TDMIS; GRANT EXECUTE ON SYS.DBMS_LOB TO TDMIS;
上述脚本创建了一个用户,在用TDMIS/vic&mis 登录的时候登录不上,请问是不是因为密码中包含&造成的 请问如何解决
解决方案 »
- group by分组查询00979报错问题
- oem问题
- 求一UPDATE语句,在线等
- 使用Odp.net,传参数Update无法更新,只有拼接字符串才有用
- oracle启动报错.ORA-01033: ORACLE initialization or shutdown in progress
- 求SQL语句
- c++中怎么调用oracle的存储过程?
- 【求助】请教下,什么是RAC节点?
- 无法执行shutdown命令
- ER图的表示方法
- 有一个表,很多字段,我想选出某一个字段(A)没有重复的记录,请问SQL如何写?
- 关于存储过程----调用 'UP_IRRGUANLIJIGOU_DELETE' 时参数个数或类型错误
输入 1 的值:
原值 1: create user testuser identified by test&1
新值 1: create user testuser identified by test用户已创建idle>grant connect to testuser;授权成功。idle>conn testuser/test&1@xiaoxiao;
输入 1 的值:
已连接。idle>conn sys/sys@xiaoxiao as sysdba
已连接。
idle>drop user testuser cascade;用户已丢弃idle>set define off;
idle>create user t1 identified by t&t1;
create user t1 identified by t&t1
*
ERROR 位于第 1 行:
ORA-00922: 缺少或无效选项
idle>create user t1 identified by "t&t1";用户已创建idle>grant connect to t1;授权成功。idle>conn t1/t&t1@xiaoxiao;
已连接。
idle>show user;
USER 为"T1"