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.

Leave a Reply

Your email address will not be published. Required fields are marked *