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 Sparse columns and when do we need it?
Sparse Columns: Sparse columns are very much useful while
-
Explain any 3 of CODD’s Rules
Edgar F. Codd, proposed thirteen rules (0 to 12)
-
What is a Dirty page?
Dirty page When we do any modification in the
Leave a Reply