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 are Global variables in SQL Server and how to create them?
In SQL Server, there is NO concept of Global
-
What are the types of Triggers available in SQL Server?
Types of Triggers: DDL Triggers DML Triggers After Triggers
-
What are the Constraints and list the available constraints in SQL
Constraint: SQL Constraints are the rules created on tables
Leave a Reply