The User List

You can grant privileges to an individual user or to a list of users. You can also specify the PUBLIC keyword to grant privileges to all users.
User List
Read syntax diagramSkip visual syntax diagramPUBLIC,user'user'
Element Description Restrictions Syntax
user Login name of a user to whom you are granting privilege or granting a role Must be a valid authorization identifier Owner name
The following example grants the Insert table-level privilege on table1 to the user mary in a database that is not ANSI-compliant: 
GRANT INSERT ON table1 TO mary;

In an ANSI-compliant database, if you do not include quotation marks as delimiters around user, the name of the user is stored in uppercase letters.