Object Privileges «Prev 

GRANT command

GRANT privilege/ALL ON object 
TO user/PUBLIC

  1. GRANT: A required keyword.
  2. privilege/ALL: privilege is the name of a specific privilege. The ALL keyword means that all privileges will be granted on the target object to the specified user.
  3. ON: A required keyword.
  4. object: The name of the table or view to which the privileges apply.
  5. TO: A required keyword.
  6. user/PUBLIC: user is the name of an existing Oracle user. The keyword PUBLIC refers to a special user group that applies the privilege to all users of the database.

SYS

When you create an Oracle Database, the user SYS is automatically created and granted the DBA role.All of the base tables and views for the database data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle Database. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by the database. They should never be modified by any user or database administrator, and no one should create any tables in the schema of user SYS. (However, you can change the storage parameters of the data dictionary settings if necessary.) Ensure that most database users are never able to connect to Oracle Database using the SYS account.

SYSTEM

When you create an Oracle Database, the user SYSTEM is also automatically created and granted the DBA role. The SYSTEM username is used to create additional tables and views that display administrative information, and internal tables and views used by various Oracle Database options and tools. Never use the SYSTEM schema to store tables of interest to non-administrative users.