Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    9

    Unanswered: Rename Login users in Sybase

    Hi ,

    I wanted to rename the login users in sybase. Is it possible . If yes then please tell me how to achieve this .

    Thanks in advance
    Pankaj Singh

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    You could edit the field 'name' in the master..syslogins-table. First execute
    > sp_configure "allow update", 1
    > go
    to allow updates on system tables.
    Then, update the table with
    > update syslogins set name = "new name" where name = "old name"
    > go
    Finally, disable the editting of system tables:
    > sp_configure "allow update", 0
    > go
    It is not recommended to edit system tables, and I have no idea how ASe will react on it when this user is logged in at the time of editting. Be careful with it.
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Feb 2007
    Posts
    71
    dont forget to create the users with the new login

  4. #4
    Join Date
    Apr 2007
    Posts
    8
    no worries if user already exists in database with the old login name as ase uses srvid to link and keep login names in line with sysusers

Posting Permissions

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