To create a user accessible only by the operating system account george, prefix george by the value of the initialization parameter OS_AUTHENT_PREFIX. For example, if this value is "ops$", you can create the user ops$george with the following statement:
CREATE USER ops$george
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE accs_ts
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON accs_ts;
The user ops$george has the following additional characteristics:
. Default tablespace accs_ts
. Default temporary tablespace temp_ts
. Unlimited space on the tablespaces accs_ts and temp_ts
. Limits on database resources defined by the DEFAULT profile
CREATE USER ops$george
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE accs_ts
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON accs_ts;
The user ops$george has the following additional characteristics:
. Default tablespace accs_ts
. Default temporary tablespace temp_ts
. Unlimited space on the tablespaces accs_ts and temp_ts
. Limits on database resources defined by the DEFAULT profile
解决方案 »
- oracle 初学者求问贴:
- ORACLE表字段有中文和字母2种,怎样安英文字母顺序排序;
- 一个oracle navicat的问题
- 高分请教与探讨,关于long和long raw移植的问题...
- 这个语句写错了,麻烦帮改一下?
- 數據苦連接問題
- 简单问题,oracle816安装完成如何建库建表(要求全部用OEM完成,总分160不够再加)。
- 怎样用ADO向oracle写数据!!谢谢
- Oracle中触发器与外部程序通信的问题!
- 求救:oracle817客户在98sec下无法安装,jrew无效页错误!
- oracleTNSlistenser80不能自动打开???????????
- 救命,用VC+Oracle+ADO(网上下载的类)遇到不能使用Update语句的问题
你还需要设置
remote_os_authent为true