Tuesday, March 20, 2012

Creating stripped accounts for accessing MS SQL Server

Hi there,
I tried to find an answer to my question but I wasn't able to find it on the Web. Maybe you guys could help me out.
I have an installation of MS SQL 2000. I made a new login on the database with only "select" permissions on a few views in one database. But when I use the account with a copy of SQL Server Manager, all databases on the instance of SQL Server are visible as well as the log files, DTS'es et cetera. Is there a way to 'strip' the account so only the views I want are visible and nothing more?
TIA,
Michiel
Leiden, The Netherlands.Unfortunately No. Enterprise Manager by default displays all databases,
though you don't have access to all of them.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"MiKE" <anonymous@.discussions.microsoft.com> wrote in message
news:B9031289-38B7-49E7-8A2D-8FF180EE20C3@.microsoft.com...
Hi there,
I tried to find an answer to my question but I wasn't able to find it on the
Web. Maybe you guys could help me out.
I have an installation of MS SQL 2000. I made a new login on the database
with only "select" permissions on a few views in one database. But when I
use the account with a copy of SQL Server Manager, all databases on the
instance of SQL Server are visible as well as the log files, DTS'es et
cetera. Is there a way to 'strip' the account so only the views I want are
visible and nothing more?
TIA,
Michiel
Leiden, The Netherlands.|||>--Original Message--
>Unfortunately No. Enterprise Manager by default displays
all databases,
>though you don't have access to all of them.
And is there something to do to prevent the user to view
the DTSes that are on the server, or to prevent the user
from making new ones?
thanks again,
Michiel

No comments:

Post a Comment