What table contains user data

(0) Share

Report

Posted on by Howard Shen

239

We regularly give our users more access in our test than in our production to test our different functionality. However, when we copy our production data to test, those rights are over written. I want to export them before I copy the data over then import them back in after the copy. What table do I need to include in the definition group for this to work?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Howard Shen 239 on at

Like (0)

Report

Re: What table contains user data

Thank you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Re: Re: What table contains user data

Alert is in EventRule table

Was this reply helpful? Yes No
Satish Agarval Anna... 5 on at

Like (0)

Report

Re: What table contains user data

Hi

SysCompanyUserInfo is the main table which contains the Windows User and Assigned User(Ex Employee) Information.

Regards

Satish Agarval

Was this reply helpful? Yes No
Howard Shen 239 on at

Like (0)

Report

Re: Re: What table contains user data

Would that include alerts and options?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: What table contains user data

dbo.userinfo contains users' domain, language, sid,etc.

Was this reply helpful? Yes No