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 the basic datatypes Char and Varchar?
Char 1. It is fixed memory allocation. Ex: —————————————————-
-
How do you choose columns to create indexes in a table?
We should create indexes on the columns which are,
-
What is an Identity property?
An Identity Column in a table is a column
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply