Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mapping Users

Status
Not open for further replies.
bikerboy718

bikerboy718

Programmer
Feb 11, 2005
195
US
Is there a way to map all users to a particular database?

I have a server with multiple users that have there own databases. In addition to there own databases I need to grant them all access to a repository database. Without going through each user login is there a way for me to grant them all access?

With Great Power Comes Great Responsibility!!! [afro]

Michael
 
Sort by date Sort by votes
Figured out a solution to this one. Did not have to grant all users access to the repository database since only a couple would be using the feature. Did write a script to give all users access in case this changed in the future though.

With Great Power Comes Great Responsibility!!! [afro]

Michael
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

csupriest
  • Locked
  • Question
script users
Replies
1
Views
112
ecobb
ecobb
awaria
  • Locked
  • Question
Provide Utility to Users to run Jobs
Replies
1
Views
93
SQLBill
SQLBill
stevo1961
  • Locked
  • Question
Issue with Concurrent Users
Replies
1
Views
87
fredericofonseca
fredericofonseca
chriscrowhurst
  • Locked
  • Question
Linked server : access to the remote server is denied because no login-mapping exists. 1
Replies
5
Views
478
SQLBill
SQLBill
wbodger
  • Locked
  • Question
SQL Server users and groups 1
Replies
6
Views
53
wbodger
wbodger

Part and Inventory Search

Sponsor

Back
Top