SQL Source Control

Latest version: 3.1

SQL Source Control

Knowledge base

Setting permissions for SQL Source Control

Date: 27/11/2012
Product: SQL Source Control

To use SQL Source Control, users need permissions to:

  • execute functions on tempdb
  • alter databases linked to source control

These permissions are usually granted by default.

Permission to execute functions on tempdb

You can test if you have this permission by running this SQL (where <dbname> is your database name):

SELECT HAS_PERMS_BY_NAME('tempdb', 'database', 'EXECUTE')

If the returned value is 1, you have this permission.

If needed, administrators can grant this permission with this SQL (where <user> is a user or role):

use tempdb

GRANT EXECUTE TO <user>

Permission to alter databases linked to source control

You can test if you have this permission by running this SQL (where <dbname> is your database name):

SELECT HAS_PERMS_BY_NAME('<dbname>', 'database', 'ALTER')

If the returned value is 1, you have this permission.

If needed, administrators can grant this permission with this SQL (where <user> is a user or role):

USE <dbname>

GRANT ALTER TO <user>

Was this article helpful?

Search support
Forums
Visit the SQL Source Control forum.
Learning SQL Source Control
Knowledge base

SQL Source Control

all SQL products

all products

Notes & articles

SQL Source Control

all SQL products

all products

Demos & walkthroughs

SQL Source Control