What are the GRANT permissions we can give to different types of database objects?
GRANT
Tables: SELECT, INSERT, UPDATE DELETE and REFERENCES
Views: SELECT, INSERT, UPDATE DELETE and REFERENCES
Stored Procedures: EXECUTE
Scalar valued functions: EXECUTE and REFERENCES
Table valued functions: SELECT, INSERT, UPDATE DELETE and REFERENCES
Note:
We cannot grant permissions to Triggers since they execute automatically when an event occurs in a database.
Related Posts
-
What are Global variables in SQL Server and how to create them?
In SQL Server, there is NO concept of Global
-
Why/When do we need Cross Join?
Cross Join: It is a kind of join that
-
How many Instead Of Triggers we can create on a table?
Only one Instead of Trigger per operation(Delete/Insert/Update) is possible
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply