April 12, 2007 at 12:44 am
Hi
I have multiple databases created in sql2000 and my server is on a network where client machines also has their own sql server instances with databases and we all are using a standard username of "sa" and password :microsoft"
This allows all the users over the network to register each one's sql server on their own local machines and access all databases
Now I want to block certian users from accessing certain databases on my server, kindly anybody help me doing this?
April 12, 2007 at 7:41 am
Stop using sa
No other way. Use a limited user, even a standard one, that has rights, like db_owner to particular databases.
April 12, 2007 at 1:57 pm
Stop using Sa and implement Windows authentication using Windows Groups or windows accounts. By using groups and group membership there will be less SQL login /user administration.
April 13, 2007 at 2:37 am
As above plus re-consider why you need individual instances on PCs and how on earth you can keep them all patched up to the same standard. Centralised servers are so much easier to maintain.
April 13, 2007 at 6:44 am
Shailesh,
Change the sa password on the server. Then give the developers access only to what they need via a different identity. Either a trusted connection via domain security or a different sql user.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply