oracle help manual

最新推荐文章于 2025-11-11 23:53:02 发布

原创最新推荐文章于 2025-11-11 23:53:02 发布 · 128 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #SQL #SQL Server

DB 专栏收录该内容

5 篇文章

订阅专栏

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

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.