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.
-
How do you check whether the given table exists in your database or not?
There might be multiple ways to check for a
-
What is Index Scan and Index Seek?
Any technical guy in this world can write code
-
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