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.