大神们 这是什么问题? 搞半天没搞出来

1

1.png

 
已邀请:
0

老头子 - 专注是唯一的捷径 2016-10-10 回答

很明显是你机器没权限
 
你想这样登录 首先得看你的安全策略,是系统认证还是权限认证
 
看你sqlnet.ora里下面这个的值,是否可以无密码登录
SQLNET.AUTHENTICATION_SERVICES

To enable one or more authentication services. If authentication has been installed, then it is recommended that this parameter be set to either none or to one of the listed authentication methods.
 
Values

Authentication methods available with Oracle Net Services:

none for no authentication methods, including Microsoft Windows native operating system authentication. WhenSQLNET.AUTHENTICATION_SERVICES is set to none, a valid user name and password can be used to access the database.

all for all authentication methods.

beq for native operating system authentication for operating systems other than Microsoft Windows

kerberos5 for Kerberos authentication

nts for Microsoft Windows native operating system authentication

radius for Remote Authentication Dial-In User Service (RADIUS) authentication

tcps for SSL authentication


 
更多资料:
http://docs.oracle.com/cd/E118 ... F2035
0

GeorgeYao - 路漫漫其修远兮,吾将上下而求索! 2016-10-10 回答

普通用户没权限,你可以用有DBA角色身份以SYSDBA登陆 然后授予该user建表权限 grant create table to 用户名 或者直接授予DBA角色 grant DBA to 用户名
 

要回复问题请先登录注册