sqlplus 命令行赋权限

Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\yums>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 12月 11 15:02:23 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

请输入用户名:  sys/sys as sysdba

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开

C:\Users\yums>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 12月 11 15:02:45 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

请输入用户名:  xzsp
输入口令:

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> grent select on XZSP_APPLY_REGBOOK to clp
SP2-0734: 未知的命令开头 "grent sele..." - 忽略了剩余的行。
SQL> grant select on XZSP_APPLY_REGBOOK to clp
  2  /

授权成功。

SQL> grant select on XZSP_APPLY_ITEM to clp
  2  /

授权成功。

SQL>