5
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 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.
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.
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
#1
André Arnaud de Cal...
291,885
Super User 2024 Season 2
#2
Martin Dráb
230,569
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
