Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

database acess Expand / Collapse
Author
Message
Posted Thursday, April 12, 2007 12:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 13, 2007 7:41 AM
Points: 3, Visits: 1

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?

 

Post #357723
Posted Thursday, April 12, 2007 7:41 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:05 PM
Points: 31,284, Visits: 15,750
Stop using sa

No other way. Use a limited user, even a standard one, that has rights, like db_owner to particular databases.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #357833
Posted Thursday, April 12, 2007 1:57 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 4:43 PM
Points: 2,506, Visits: 425

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.

Post #358018
Posted Friday, April 13, 2007 2:37 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 6:49 AM
Points: 570, Visits: 1,239
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.
Post #358120
Posted Friday, April 13, 2007 6:44 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, June 22, 2014 6:53 PM
Points: 967, Visits: 388

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.

Post #358168
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse