GRANT使用

文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm#i2062455

grant_object_privileges::=

Description of the illustrationgrant_object_privileges.gif

 

--grant的语法：在授予对象权限的时候，可以针对视图或者表的对象权限也能够指定权限应用到表或者视图的具体哪一列上或者多列上。如果不指定，即意味着全部的列。

 

grant_object_privileges

Use these clauses to grant object privileges.

object_privilege

Specify the object privilege you want to grant. You can specifyany of the values shown in Table 18-3. See also Table 18-4.

Restriction onObject Privileges A privilege cannot appear more than oncein the list of privileges to be granted.

ALL[PRIVILEGES]

Specify ALL to grant all the privileges for theobject that you have been granted with the GRANTOPTION. The user who owns the schema containing anobject automatically has all privileges on the object with theGRANT OPTION. The keywordPRIVILEGES is provided for semantic clarity and isoptional.

 

column

 

Specify the table or view column on which privileges areto be granted. You can specify columns only whengranting the INSERT, REFERENCES, orUPDATE privilege.

--指定在表或者视图上的列。你仅仅能够在授予INSERT, REFERENCES, orUPDATE 权限的时候指定列

 

 

 If you do not list columns, then thegrantee has the specified privilege on all columns in the table orview.

 

For information on existing column object grants, query theUSER_, ALL_, orDBA_COL_PRIVS data dictionary view.