Schemas

Granting limited permissions to create views in another schema in SQL Server - Part 2

  • Article

In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.

2009-08-17

3,444 reads

Using schema binding to improve SQL Server UDF performance

  • Article

SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.

2009-03-09

4,200 reads

Blogs

Daily Coping 5 June 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

By

I’m working on a project where it’s useful to automate environment setup and teardown...

SQL Server Authentication

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Read the latest Blogs

Forums

Attunity Oracle Connector Not Showing Up in SSIS Toolbox

By brad.mccollum

I've just about exhausted every effort I can research and absolutely cannot get the...

Covert a string to simple sql datetime format

By Jeff Sims-413169

Can anyone help me out here.  I need to convert strings in a file...

Creating a DB

By Nusc

Hi there, when creating a DB with Auto close= False Auto shrink= True Database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers