Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1062
  • Last Modified:

update SID directly

is it possible/advised to update the SID directly on syslogins and sysusers?

thanks
0
anushahanna
Asked:
anushahanna
  • 2
2 Solutions
 
owaisyahyaCommented:
update sysusers set sid = '123' where name = 'USER01'
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I would not recommend doing so. sysusers is a system table, and the SID is used to link between other system tables ...
0
 
anushahannaAuthor Commented:
a3, is it safe to do on syslogins? there is a situation where need the logins to have same sid across 2 instances. if the logins have that sid, then i make sure user also gets that sid by the command: CREATE USER FOR LOGIN...
0
 
owaisyahyaCommented:
if you really want to update sid change it on both tables (syslogin and sysuser)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now