How can I not give DBO (Database Owner) permissions?

How can I not give DBO (Database Owner) permissions?

This query is useful for when the client doesn’t want to give DBO (Database Owner) permissions. Instead it will make the user a DDLadmin, meaning all they have to do is run the query on the database then add the user (or users) to the Arkieva_users group. 
 
DBO Alternative Permissions Query:

CREATE ROLE arkieva_users

GRANT EXECUTE TO arkieva_users

EXEC sp_addrolemember 'db_datareader', 'arkieva_users'

EXEC sp_addrolemember 'db_datawriter', 'arkieva_users'

EXEC sp_addrolemember 'db_ddladmin', 'arkieva_users'


    • Related Articles

    • Terminal server is connecting to the wrong database?

      Terminal server connects to wrong database in case of server cloning. Checks: Check db config Check the dbo.json files Check api root: http://zarkvs01/Arkieva/api/v1/config/databases Check config files on terminal server At a client, first we had ...

    • Connect to Azure Web Database?

      Currently it is not possible to connect to Azure because the database discovery service is not configured to work with Azure. 

    • Database 'master' error when generating upgrade script?

      Create Database permission denied in database 'master' error when generating upgrade script occurs when the user does not have sufficient rights on the server.

    • Getting duplicate keys error when adding new user to database?

      Duplicate keys could mean there is a duplicate table in the database. An example is a remnant in the data source view from a table being renamed then added back again into the system model. You can run the below queries together in the database to ...

    • Database discovery not showing up?

      When checking through the environment, we found the Arkieva api was starting and stopping. Checking the event viewer showed the below error, which points to their being a problem with the password of the service account. Changing the password to the ...