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

|--+-PUBLIC---------+-------------------------------------------|
   | .-,----------. |   
   | V            | |   
   '---+-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.