Results 1 to 2 of 2

Thread: How to create a new user with automatic access to all db's

  1. 01-11-2005, 04:24 AM #1
    future2000
    future2000 is offline Registered User
    Join Date
    Jan 2005
    Location
    Guildford, UK
    Posts
    1

    Unhappy How to create a new user with automatic access to all db's

    Hi,

    I wonder if anyone can help. I'm trying to create a new user/login to a sql server 2000 box which will automatically have access to all the user databases on the instance. The user can't be a SA or anything however. It seems this can be done as the application which uses all these database has created such a user, however I need another which I will then make read-only.

    Any ideas?

    Thanks in advance

    future2000!
    Reply With Quote Reply With Quote
  2. 01-11-2005, 10:04 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You have to write script to add login as db user.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules