• The APS Catalog has been deprecated and removed from all Plesk Obsidian versions.
    Applications already installed from the APS Catalog will continue working. However, Plesk will no longer provide support for APS applications.
  • Please be aware: with the Plesk Obsidian 18.0.78 release, the support for the ngx_pagespeed.so module will be deprecated and removed from the sw-nginx package.

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
6K
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