The following example grants the Insert table-level privilege on table1 to
the user mary in a database that is not ANSI-compliant:
GRANTINSERTON 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.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.