Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    4

    Question Unanswered: Need stored proc to make aliases to users...

    I need a stored proc to make all aliases to users, then assign these newly created users to the same db's (which the aliases were assigned to).

    Are there any other ways, or just to write a stored proc?

    ANY suggestions accepted, just pls help, i need this for yesterday, and have not much experience in this

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Have a look at SP_ADDALIAS under BOL.

    HTH

  3. #3
    Join Date
    Oct 2002
    Posts
    4

    Angry

    Originally posted by Satya
    Have a look at SP_ADDALIAS under BOL.

    HTH
    I mean I want to change the aliases to users, not to add an alias to a user.
    (eg. you have a db, and there are 50 users and 10 aliases. You don't want to use aliases. So you have to make users from them.)

    I need help in this, sorry is anybody misunderstood

    So I have to drop all aliases, and create users with the same names, and assign them to the correct db-s.

    But this have to work automatically...any scripts? commands?...etc

Posting Permissions

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