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
解决方案 »
- 求个简单存储过程!谢了
- 如何从有几万条记录的数据表中快速查找到自己需要的数据
- ASM 磁盘组怎么配置?必须使用ASMlib吗?不使用ASMlib的话该如何配置
- OracleOraHome92mManagementServer启动问题
- 简单问题 tablespace 相当于SQL中的什么? 能说详细点吗?
- jdbc与oracle连接问题
- 在SQLPlus Worksheet中调试过程,错误!
- 高手请进(50分)
- 这个事务处理如何写,不太好办,不过这个问题很常见.
- 求一Sql语句,由列到行转换的问题
- oracleTNSlistenser80不能自动打开???????????
- 救命,用VC+Oracle+ADO(网上下载的类)遇到不能使用Update语句的问题
你还需要设置
remote_os_authent为true