• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

Microsoft SQL Server Management Studio Express

Hi,

Yes it works, but they are able to see(not use) all mssql databases on that server. I only want them to see there own databases. Is there a cure for that ?

Regards,
Michel.
 
yes there is a way.

First you have to create the DB and then create the user their user account in SQL. Then change the owner of the DB from SA to the sql user you created and map that user account to the dbo role of that db.

then when that user logs in they can only see their database.
 
You must log in or register to reply here.

Similar threads

q-quan
Resolved Windows Server 2025 - Plesk Obsidian 18.0.69 - msodbcsql17 dependency
Replies
11
Views
5K
iForced
I
E
Resolved Plesk Error : SQLSTATE[08S01]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host
Replies
2
Views
3K
esfahanhost
E
T
Contribution [HOW-TO] Migration of Plesk roundcubemail to new server
Replies
2
Views
3K
ChristophRo
ChristophRo
P
Question Microsoft SQL Server 2022 support
Replies
1
Views
2K
IgorG
IgorG
S
Issue Need help: SQLSTATE[08001][Microsoft][ODBC Driver 18 for SQL Server]SSL Provider
Replies
5
Views
13K
samsam
S
Back
Top