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.
-
What is the difference between MINUS and LEFT JOIN in SQL Server?
This question seems to be very easy and you
-
What are Catalog Views?
Catalog Views were introduced by Microsoft in SQL Server
-
What are the isolation levels available in SQL Server while working with Transactions?
Isolation Levels: Below are the list of 5 available
Leave a Reply