An error is received in the workbench when attempting to create/upgrade the ChangeBASE database. Insufficient privileges to perform database upgrade/creation.
User does not have sufficient permissions in SQL to perform this action.
Use the following guidelines when assigning permissions in SQL for the ChangeBASE database:
For initial setup of tables within the ChangeBASE database and upgrading the database the user must either be dbo, or be assigned the following permissions in SQL:
,
Database role | db_datareader | Database-level permission: Granted: SELECT |
Database role | db_datawriter | Database-level permission Granted: DELETE, INSERT, UPDATE |
Database role | db_ddladmin | Database-level permission Granted: ALTER ANY ASSEMBLY, ALTER ANY ASYMMETRIC KEY, ALTER ANY CERTIFICATE, ALTER ANY CONTRACT, ALTER ANY DATABASE DDL TRIGGER, ALTER ANY DATABASE EVENT, NOTIFICATION, ALTER ANY DATASPACE, ALTER ANY FULLTEXT CATALOG, ALTER ANY MESSAGE TYPE, ALTER ANY REMOTE SERVICE BINDING, ALTER ANY ROUTE, ALTER ANY SCHEMA, ALTER ANY SERVICE, ALTER ANY SYMMETRIC KEY, CHECKPOINT, CREATE AGGREGATE, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE QUEUE, CREATE RULE, CREATE SYNONYM, CREATE TABLE, CREATE TYPE, CREATE VIEW, CREATE XML SCHEMA COLLECTION, REFERENCES |
Stored procedures | EXECUTE | The user must be granted rights to execute stored procedures in the database. This can be achieved by executing this SQL command against the database: , grant execute to <Database username*> (* case sensitive) |
For normal day-to-day usage of ChangeBASE the database user must be assigned the following permissions in SQL(the database level permissions are also shown). Note that the individual functions within ChangeBASE is managed through the security tab.
,
Database role | db_datareader | Database-level permission: Granted: SELECT |
Database role | db_datawriter | Database-level permission Granted: DELETE, INSERT, UPDATE |
Stored procedures | EXECUTE | The user must be granted rights to execute stored procedures in the database. This can be achieved by executing this SQL command against the database: , grant execute to <Database username*> (* case sensitive) |
,
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center