• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Question user sees all DB's in MSSQL (Plesk 12.5)

S

Schrikbeest

New Pleskian
One of our clients complaints that he sees all the databases in MSSQL on our shared hosting server. The server runs 2012 with MSSQL 2012. He cant mutate the databases other than his own but we would like to achieve that our clients only see their own db's.

I checked but there is no guest account (http://forum.parallels.com/showthread.php?106115).

We tried running this script "DENY VIEW ANY DATABASE TO public" but the result is that the db owner cant see his own database anymore.

Is there a solution for this issue?
 
Dont think there is. I read somewhere its how MSSQL is by design. We even tried signing up with other hosting providers just to see if this is the case like Godaddy and then some local hosts in south africa and found it the be the case with all them. You can view all but cant edit them. I wish there was a solution but every solution tried causes other issues.
 
You must log in or register to reply here.

Similar threads

B
Issue High latency, unreliable performance & 522 errors on a Plesk server that ran fine for 6+ months
Replies
8
Views
2K
HHawk
HHawk
H
Issue MSSQL Server access of db users lost when updated to Plesk Obsidian 18.0.44 Update 2
Replies
0
Views
877
Harsha Parchure
H
E
Resolved how to point a subdomain to a wildcard on nginx
Replies
9
Views
3K
Epizefiri
E
hardbrasil
Question web applications requiring custom envoiriments
Replies
3
Views
2K
Dave W
Dave W
B
  • Locked
Issue own Name Server does not work
Replies
9
Views
3K
Peter Debik
P
Back
Top