Permission required for using object locking

• 
  Hi Chris,
  
  Thanks for getting in touch. If you are trying to figure out what permissions are required these are shown below:- (These permissions are for running the actual script)
  
  To run the setup script, you need these database privileges:
  CREATE USER
  CREATE ROLE
  GRANT ANY PRIVILEGE
  CREATE ANY TABLE
  CREATE ANY PROCEDURE
  You don't need the privileges to lock and unlock objects.
  
  If the DBA is still seeing the info about setting up locking can you check that he has run the script successfully first. Please let me know if this isn't successful.
  
  Thanks
  

  Ben M May 19, 2017 12:01

  - 0 +
• 
  Hi Ben, the DBA has successfully executed the script and can lock/unlock objects. It is me who still sees the message about setting up locking. We're assuming that I need some additional permissions to use locking? I'm in the db_owner role on the database we're developing but have no access to the RedGate database. Chris

  chris_godfree May 19, 2017 13:07

  - 0 +
• 
  Hi Chris,
  
  You'll need to make sure you have EXEC permission for the following:-

  • the function SQLSourceControl.GetLockedObjects, to retrieve locked objects
  • the function SQLSourceControl.IsObjectLocked, to check if objects are locked
  • the stored procedure SQLSourceControl.LockObject, to lock objects
  • the stored procedure SQLSourceControl.UnlockObject, to unlock objects

  
  If you don't then ask your DBA to set this up for you and it should resolve the problem.
  
  Thanks
  

  Ben M May 19, 2017 15:21

  - 0 +
• 
  Thanks Ben

  chris_godfree May 22, 2017 12:08

  - 0 +

Add comment

Please sign in to leave a comment.