The syntax of the GRANT statement in Oracle and Microsoft® SQL Server™ is similar.
| Oracle | SQL Server |
|---|---|
| GRANT {ALL [PRIVILEGES][column_list] | permission_list [column_list]} ON {table_name [(column_list)] | view_name [(column_list)] | stored_procedure_name} TO {PUBLIC | name_list } [WITH GRANT OPTION] |
GRANT {ALL [PRIVILEGES] | permission_list} {[column_list] ON {table | view} | ON {table | view} [(column_list)] | ON {stored_procedure | extended_procedure} } TO security_account_list [WITH GRANT OPTION] [AS {group | role}] |