I figure there has to be a way to do this. Unfortunately, I've been
unable to turn up anything on google, so...
When I create a database in the Microsoft SQL Server, it shows up under
'Databases' in Enterprise Manager for any user who logs in, whether or not
they have permissions to access it. Since this could potentially be a
security issue, I would like to set it up so that users can only see
databases for which they've been assigned a role.
The SQL server uses mixed-mode authentication and cannot be changed.
The server in question is currently Microsoft SQL Server 7, but any advice
or pointers for Microsoft SQL Server 2000 would be appreciated as well.
Sincerely,
Chris Ess
System Administrator / CDTT (Certified Duct Tape Technician)
------------------------------------------------------------------------
---
Network with over 10,000 of the brightest minds in information security
at the largest, most highly-anticipated industry event of the year.
Don't miss RSA Conference 2004! Choose from over 200 class sessions and
see demos from more than 250 industry vendors. If your job touches
security, you need to be here. Learn more or register at
http://www.securityfocus.com/sponsor/RSA_focus-ms_031027
and use priority code SF4.
------------------------------------------------------------------------
---
unable to turn up anything on google, so...
When I create a database in the Microsoft SQL Server, it shows up under
'Databases' in Enterprise Manager for any user who logs in, whether or not
they have permissions to access it. Since this could potentially be a
security issue, I would like to set it up so that users can only see
databases for which they've been assigned a role.
The SQL server uses mixed-mode authentication and cannot be changed.
The server in question is currently Microsoft SQL Server 7, but any advice
or pointers for Microsoft SQL Server 2000 would be appreciated as well.
Sincerely,
Chris Ess
System Administrator / CDTT (Certified Duct Tape Technician)
------------------------------------------------------------------------
---
Network with over 10,000 of the brightest minds in information security
at the largest, most highly-anticipated industry event of the year.
Don't miss RSA Conference 2004! Choose from over 200 class sessions and
see demos from more than 250 industry vendors. If your job touches
security, you need to be here. Learn more or register at
http://www.securityfocus.com/sponsor/RSA_focus-ms_031027
and use priority code SF4.
------------------------------------------------------------------------
---
[ reply ]