dbdao吧 关注:1,185贴子:4,073
  • 2回复贴,共1

oracle用户分配权限问题

只看楼主收藏回复

我给别人新增了一个oracle用户,在我本地测试用plsql连是可以的,但是给别人的时候登录会报ora-12545,再把我另一个账号给他,可以正常登录,请问怎么新增一个只读权限的oracle用户?


1楼2015-11-16 16:59回复
    [oracle@dbdao03 ~]$ oerr ora 12545
    12545, 00000, "Connect failed because target host or object does not exist"
    // *Cause: The address specified is not valid, or the program being
    // connected to does not exist.
    // *Action: Ensure the ADDRESS parameters have been entered correctly; the
    // most likely incorrect parameter is the node name. Ensure that the
    // executable for the server exists (perhaps "oracle" is missing.)
    // If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
    // host name to a numeric IP address and try again.
    12545 错误和权限没什么关系, 一般是用了无法解析的hostname 或者其他网络问题


    2楼2015-11-16 21:57
    收起回复