• We value your experience with Plesk during 2025
    Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
    Please take this short survey:

    https://survey.webpros.com/

Grant the ALTER DATABASE permission to all Microsoft SQL Server database users

HoracioS

Regular Pleskian
Hello,

In Plesk 12.0.18 #4 I checked Grant the ALTER DATABASE permission to all Microsoft SQL Server database users .
The problem is I cannot rename database tables or other functions with myLittleAdmin for SQL provided with Plesk.
My question is: Am I doing something wrong or is needed to upgrade the myLittleAdmin license to Full version?

Best regards,
Horacio
 
Yes, by default free lite edition of MLA is installed which do not allow to rename user's databases. You need to install full MLA license for enabling all features.
 
Hello,

I have the same problem but from the SQL Management Studio (I try to alter a Index to table from MSSQL Management Studio logged with user for db and he denies for permission).
 
Back
Top