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 Temporary tables and Table Variables?
My suggestion is go for Table variables when we
-
What is the default TCP/IP port number does SQL Server run on?
SQL Server runs on 1433 port number. Happy Reading
-
What is the basic difference between DELETE and TRUNCATE commands?
DELETE It is a DML command We can use
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply