Finance | Project Operations, Human Resources, ...

Can't grant DYNSA access to a company

(0) Share

Report

Posted on by scplimited

I created a test company and oops had the copy over user access checked. I was able to delete the other users in the company database in SMSS to fix them but I can't do that with DYNSA as it's associated with the dbo. So how can I resolve this?

The error btw is "The user could not be added to one or more databases."

And the error is specifically for granting user DYNSA access to ta company in GP under User Access Setup.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Derek Albaugh Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Can you run the following scripts:

--Against each GP company database

sp_dropuser 'DYNSA'

sp_changedbowner 'DYNSA'

DYNSA should be the db owner for each GP database, which gives them access to the database, they shouldn't be setup as a regular user.

Under the User Access window, DYNSA should have all GP company databases showing as marked, indicating access to each one.

DYNSA also has PowerUser permissions in each company database.

Thanks

Was this reply helpful? Yes No
scplimited 5 on at

Like (0)

Report
Copy link

Link copied!

I got a:

Msg 15008, Level 16, State 1, Procedure sp_dropuser, Line 12

User 'DYNSA' does not exist in the current database.

for sp_dropuser 'DYNSA"

but sp_changedbowner 'DYNSA' completed fine

I'm probably going to show up as a different user but it is still me. Was rather annoyed when this orig account needed a new token or whatever.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

I would suggest posting a picture of the User List under the database in question -- Security -- shows all active users.

If the DYNSA is not listed in the specific company, then have a look in the DYNAMICS database -- Security >> Logins - find the DYNSA user - double click - and look at the User Mapping and see what databases are connected.

Have a look and post whatever details that you think might help - like list of names

Good luck.

Was this reply helpful? Yes No