Home > Articles > Data > SQL Server

  • Print
  • + Share This

The CREATE TABLE, VIEW, FUNCTION, PROCEDURE, DEFAULT, and RULE Permissions

CREATE TABLE, VIEW, FUNCTION, PROCEDURE, DEFAULT, and RULE permissions enable users to run the referenced statement to create objects in the database where the permissions were given. Programmers are frequently given these permissions to allow them to create the resources they need in a database during development.

CAUTION

All CREATE permissions include the right to alter or drop any objects created by a user. Giving this permission can cause serious problems in your database because a user can drop objects he is finished with, only to find that others were using the object. A user might also alter an object and make it unusable to some other user in the database. To check for these types of dependencies, you can run the sp_depends system stored procedure.

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.