- Statement Permissions
- The CREATE TABLE, VIEW, FUNCTION, PROCEDURE, DEFAULT, and RULE Permissions
- The BACKUP DATABASE and BACKUP LOG Statement Permissions
- Assigning Statement Permissions
- Administering Statement Permissions with SQL Server Enterprise Manager
- About this Article
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.
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.