According to your description, usually, we can grants permissions on a table, view, table-valued function, stored procedure,
extended stored procedure, scalar function, aggregate function, service queue, or synonym. And there are major classed of permission, such as select, view change tracking, update, references, insert, delete, execute, receive, view definition, alter, take
ownership, control impersonate. If you want to fine a complete list of SQL Server permissions, you can review the following article about permission.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.