Let’s grant all SQL Server and database permissions to a sample user, Mara. Make sure that the appropriate user is created in the ApexSQL database to grant the minimum permissions required The following is a query that will grant the necessary SQL Server and database permissions to the user (in this case Mara) against the DevelopmentDB database: In addition to granting permissions by using the GUI (as explained above), the same can be achieved using T-SQL. Under the Properties window, switch to the Permissions tab, and for the selected user (in this case Mara) check the box in the bottom section under the Grant column, for the Alter permission: It can be found by expanding the nodes, Database – Security – Schemas – dbo: To grant this one, locate the dbo schema under the database node. Verify that the appropriate permissions are granted as shown in the image below:īesides the above-granted permissions, the user will need the Alter permission against the dbo schema. To verify that all permissions are granted, initiate the same tab again and switch from the Explicit tab to the Effective tab. Once this is done, click the OK button to apply these settings. Under the Permissions tab, highlight the user in the User or roles section (in this case we’ll use Mara), and under the Explicit tab in the bottom section, check the box in the Grant column for the appropriate permissions, Connect, Update, Insert, Alter any database DDL trigger, Select, Delete, Create function, Create table and Execute. To grant these permissions, right-click on a database in the Object Explorer pane, select the Properties from the context menu, and choose the Permissions tab to initiate the following: Make sure that the appropriate user is created and mapped to a database to grant the minimum SQL Server and database permissions requiredįor this article, Mara is used as an example for the SQL database user.
The following SQL Server and database permissions are required for the user who wants to link a database to a source control repository:
#Apex sql no database permissions how to#
Also, the article covers how to grant needed permissions to the user. This article explains the user’s minimal SQL Server and database permissions needed to work with a database using ApexSQL Source Control.