oracle help manual

iteye_15801

于 2011-01-24 13:41:28 发布

阅读量116

点赞数

分类专栏： DB 文章标签： Oracle SQL SQL Server

本文链接：https://blog.youkuaiyun.com/iteye_15801/article/details/82002474

版权

DB 专栏收录该内容

5 篇文章

订阅专栏

本文介绍如何使用SQL命令进行数据库权限管理，包括对象权限和系统权限的授予，并提供了具体命令的使用方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

cd ORACLE_HOEM/sqlplus/admin/help
sqlplus system/pwd
system@ORCL> @helpdrop.sql
system@ORCL> @helpbld.sql
system@ORCL> @helpus.sql
first input: path name()
second input: helpus.sql

system@ORCL> help grant

 GRANT (Object Privileges)
 -------------------------

 Use this command to grant privileges for a particular object to
 users and roles. To grant system privileges and roles, use the GRANT
 command (System Privileges and Roles).

 GRANT
   { object_priv | ALL [PRIVILEGES] }
   [ ( column [, column] ...) ]
   [, { object_priv | ALL [PRIVILEGES] }
      [ ( column [, column] ...) ] ] ...
 ON [ schema.| DIRECTORY] object
 TO { user | role | PUBLIC} ...
    [ WITH GRANT OPTION]

 For detailed information on this command, see the Oracle8 Server SQL
 Reference.