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 Clustered index & Non Clustered Index?
Clustered Index Data is stored in physical order. The
-
When do we use UDFs instead of Stored Procedures?
Since there are more advantages of Stored procedures over
-
What are the types of locks available in SQL Server?
There are lots of locks available in SQL Server.
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply