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 Self join and why do we need it?
There is no special type of join called Self
-
What is the difference between COUNT (*) and COUNT(Column Name)?
Count COUNT(*) – Returns the total number of records
-
How to add 5 business days to all values of a date column?
First of all do not get confused between 5
Leave a Reply