Setting db user ‘plandba’ as dbo
The user ‘plandba’ is given database administrator privileges by assigning the ‘dbo’ privilege. For more information, see
Setting the default database for user ‘plandba’1. Open MSSQL Management Studio.
2. Select the ‘Planon’ database.
3. On the toolbar, click New Query.
4. Run this stored procedure.
sp_changedbowner ‘plandba’
| Do not forget to carry out this step, as you will not be able to access the database when this step is overlooked. |